Dates are stored as an elapsed number of days from a common base date. So
if you subtract the latest date from the earliest day, the result will be
the number of days.

? datevalue("Jan 24, 2004") - DateValue("01/27/2002")
727

The above is shown in VBA, but in the worksheet if the values were in A1 and
A2 it would be =A1-A2

--
Regards,
Tom Ogilvy


ExcelMonkey wrote in message
...
How do I calc the number of days between two dates? I know that in
excel there is a days360 function but I thinkg this assumed 12 months
at 30 days each.

I have a startdate and and an end date. I want to subtract the two and
then calc # of days.


---
Message posted from http://www.ExcelForum.com/