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/

Excel Monkey,

Take a look he

http://www.cpearson.com/excel/datedif.htm

John

"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/

=DateDif(date1,date2,"d")

should work? I think.

Hope it helps.

-Bob


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

Hello,

You can check this site as well...

http://support.microsoft.com/default...Product=xl2003

Rockee


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

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/

Got tongue Tied - subtract the start date from the end date - should be
clearer.

--
Regards,
Tom Ogilvy


Tom Ogilvy wrote in message
...
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/