Counting days from a date
in [Functions]
|
From: Sunshine on 17 Feb 2010 00:11 in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be today's date...in cell D7 I need it to calculate the number of days from 2/12 to today.
From: T. Valko on 17 Feb 2010 00:46 Try this... =TODAY()-D5 -- Biff Microsoft Excel MVP "Sunshine" <Sunshine(a)discussions.microsoft.com> wrote in message news:3AA72C87-5DDE-4F4F-9D7F-820CEB68EE4B(a)microsoft.com... > in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to > be > today's date...in cell D7 I need it to calculate the number of days from > 2/12 > to today.
From: Sunshine on 17 Feb 2010 06:21 I need it to stop counting the days from D5 when I put an end date in D6 "T. Valko" wrote: > Try this... > > =TODAY()-D5 > > -- > Biff > Microsoft Excel MVP > > > "Sunshine" <Sunshine(a)discussions.microsoft.com> wrote in message > news:3AA72C87-5DDE-4F4F-9D7F-820CEB68EE4B(a)microsoft.com... > > in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to > > be > > today's date...in cell D7 I need it to calculate the number of days from > > 2/12 > > to today. > > > . >
From: T. Valko on 17 Feb 2010 11:35 Try this... =IF(D6="",TODAY(),D6)-D5 -- Biff Microsoft Excel MVP "Sunshine" <Sunshine(a)discussions.microsoft.com> wrote in message news:6DEEE7D5-35CD-4079-9726-6D6C085654CC(a)microsoft.com... >I need it to stop counting the days from D5 when I put an end date in D6 > > "T. Valko" wrote: > >> Try this... >> >> =TODAY()-D5 >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Sunshine" <Sunshine(a)discussions.microsoft.com> wrote in message >> news:3AA72C87-5DDE-4F4F-9D7F-820CEB68EE4B(a)microsoft.com... >> > in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed >> > to >> > be >> > today's date...in cell D7 I need it to calculate the number of days >> > from >> > 2/12 >> > to today. >> >> >> . >>
|
Pages: 1 Prev: MS Word equation Next: Delete some column headings from an autofiltered range. |