Counting Days Between Dates

[RockEngineer]

Is there a function or macro that will tell me the number of days between any two dates. I have readings on several dates and am trying to get the average per day between those dates.

Thanks.

 

[IRstuff]

Just subtract one from the other. Dates are stored as floating point numbers in Excel. End result is number of whole and fractional days

TTFN

FAQ731-376

 

[yank38]

Simply use a formula where you subtract the older date from the more recent date and format the cell with the formula as a number.

 

[RockEngineer]

Thanks. I forgot to reformat the answer cell as a number and it was frustrating me and giving back a wierd date as the answer.

 

[Clyde38]

Also you can use the =DATEDIF(T2,U2,"md")function. Where T2 and U2 have the two dates of interest.

 

[Clyde38]

Forgot, this will only work within the month use =DATEDIF(T2,U2,"d")for all days. See other DATEDIF posibilities.

 

[Clyde38]

I forgot to tell you where to look

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