Date minus date=No. of days?
 

Hi folks,
Apologies if my answer is here but I can't find it.
I have a task list and I need to record how many days since task
allocated.
So it's:
today - date allocated=135(days)
0r 03/03/2006-11/12/2005=82(days)

Many thanks in advance,

Scoville


--
Scoville
------------------------------------------------------------------------
Scoville's Profile: http://www.excelforum.com/member.php...o&userid=32088
View this thread: http://www.excelforum.com/showthread...hreadid=518425

Date minus date=No. of days?
 

If cell A1 is today and cell B1 is the date allocated, in cell C, which is
formatted as a number, type = A1-B1. If you need to include today, use
=A1-B1+1.

"Scoville" wrote:


Hi folks,
Apologies if my answer is here but I can't find it.
I have a task list and I need to record how many days since task
allocated.
So it's:
today - date allocated=135(days)
0r 03/03/2006-11/12/2005=82(days)

Many thanks in advance,

Scoville


--
Scoville
------------------------------------------------------------------------
Scoville's Profile: http://www.excelforum.com/member.php...o&userid=32088
View this thread: http://www.excelforum.com/showthread...hreadid=518425

Date minus date=No. of days?
 

=TODAY()-A1

where A1 is the date allocated

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scoville" wrote in
message ...

Hi folks,
Apologies if my answer is here but I can't find it.
I have a task list and I need to record how many days since task
allocated.
So it's:
today - date allocated=135(days)
0r 03/03/2006-11/12/2005=82(days)

Many thanks in advance,

Scoville


--
Scoville
------------------------------------------------------------------------
Scoville's Profile:
http://www.excelforum.com/member.php...o&userid=32088
View this thread: http://www.excelforum.com/showthread...hreadid=518425