Fuction that gives number of days of a given month

F

FGOMEZ

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

Thanks
 
D

Domenic

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

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

Hope this helps!
 
A

Arvi Laanemets

Hi

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

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


Arvi Laanemets
 
F

FGOMEZ

It helped really well.

Thanks so much Domenic

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

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

Hope this helps!
Click to expand...
 
Top