I am just wondering if there is a function that gives you the number days of
the month for a given date.

Thanks

Assuming that A1 contains a date, such as 2/15/06, try...

=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

Hope this helps!

In article ,
"FGOMEZ" wrote:

I am just wondering if there is a function that gives you the number days of
the month for a given date.

Thanks

Hi

With Analysis Toolpack installed
=DAY(EOMONTH(YourDate,0))

Without Analysis Toolpack
=DAY(DATE(YEAR(YourDate),MONTH(YourDate)+1,0))


Arvi Laanemets



"FGOMEZ" wrote in message
...
I am just wondering if there is a function that gives you the number days
of
the month for a given date.

Thanks

It helped really well.

Thanks so much Domenic

"Domenic" wrote in message
...
Assuming that A1 contains a date, such as 2/15/06, try...

=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

Hope this helps!

In article ,
"FGOMEZ" wrote:

I am just wondering if there is a function that gives you the number
days of
the month for a given date.

Thanks