Days360() is only approximate

[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

 

[Ron Rosenfeld]

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

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

 

[Paul]

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

Duh. I forgot about that.

Thanks, Ron.

 

[Ron Rosenfeld]

Thanks, Ron.

You're welcome. Glad to help
--ron