= Today() - DueDate
Formated as a number, this will give you the number of days elapsed between
Today & DueDate
Excel stores dates as whole numbers where 1 = 1 day. Simply subtracting 2
dates gives you the number of days elapsed.
(Times are stored as their decimal equivalent of a day where 0.25 = 6:00 am,
0.50 = 12 noon, 0.75 = 6:00 pm, etc.)
HTH,
--
George Nicholson
Remove 'Junk' from return address.
"jenniferm" wrote
in message ...
Hi All,
I am a new user. I would like to present my scenerio in hopes of
getting a formula figured out.
I have three columns.
The first column represents a due date (mm/dd/yy)
the second represents todays date.
In the third column I would like to have the number of days between the
two.
In other words, say the due date was 10/01/05 and today's date column
says 09/20/05, I would like the third column to compute: 10 (for 10
days remaining until 10/1).
Also, the due date might be the following year, so would still need it
to work in that case.
Thanks for any help in advance,
Jenn
--
jenniferm
------------------------------------------------------------------------
jenniferm's Profile:
http://www.excelforum.com/member.php...o&userid=27414
View this thread: http://www.excelforum.com/showthread...hreadid=469253