Days360() is only approximate

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
 
R

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
 
P

Paul

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

Duh. I forgot about that.

Thanks, Ron.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top