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

On Mon, 10 Aug 2009 16:29:27 -0700, "Paul" <(E-Mail Removed)> 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

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

Duh. I forgot about that.

Thanks, Ron.



"Ron Rosenfeld" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Mon, 10 Aug 2009 16:29:27 -0700, "Paul" <(E-Mail Removed)> 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

On Mon, 10 Aug 2009 17:03:56 -0700, "Paul" <(E-Mail Removed)> wrote:

>Thanks, Ron.

You're welcome. Glad to help
--ron