Nuber of Days between two Dates

[ExcelMonkey]

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.

 

[John Wilson]

Excel Monkey,

Take a look here:

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

John

 

[beeawwb]

=DateDif(date1,date2,"d")

should work? I think.

Hope it helps.

-Bob

 

[Rockee052]

Hello,

You can check this site as well...

http://support.microsoft.com/default.aspx?scid=kb;en-us;214094&Product=xl2003

Rockee

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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