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