Days360() is only approximate

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I've noticed that the Days360() function assumes all months have 30 days,
and for that reason it doesn't give an exact count of the actual number of
calendar days if the interval covers months that do not have exactly 30
days.

Is there a function in Excel I can use to get the exact number of calendar
days over any date interval?

Thanks in advance,

Paul
 
I've noticed that the Days360() function assumes all months have 30 days,
and for that reason it doesn't give an exact count of the actual number of
calendar days if the interval covers months that do not have exactly 30
days.

Is there a function in Excel I can use to get the exact number of calendar
days over any date interval?

Thanks in advance,

Paul
Click to expand...

Excel stores dates as serial numbers. Just subtract one from the other.

e.g.

A1: 1/5/2009
A2: 1/10/2009

=A2-A1
--ron
 
Excel stores dates as serial numbers. Just subtract one from the other.

Duh. I forgot about that.

Thanks, Ron.
 
Back
Top