Days360() is only approximate
 

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

Days360() is only approximate
 

On Mon, 10 Aug 2009 16:29:27 -0700, "Paul" wrote:

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

Days360() is only approximate
 

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

Duh. I forgot about that.

Thanks, Ron.



"Ron Rosenfeld" wrote in message
...
On Mon, 10 Aug 2009 16:29:27 -0700, "Paul" wrote:

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

Days360() is only approximate
 

On Mon, 10 Aug 2009 17:03:56 -0700, "Paul" wrote:

Thanks, Ron.

You're welcome. Glad to help
--ron