Date minus date=No. of days?

S

Scoville

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
 
S

SVC

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.
 
B

Bob Phillips

=TODAY()-A1

where A1 is the date allocated

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top