If the date is in cell D6, the following formula in E6 formatted as "dd"
will give you the number of days.

=DATE(YEAR(D6),MONTH(D6)+1,0)

It would need to be a "proper date", for example, 16/02/2007. This would
display as 28

Regards

Trevor


"Jepane" wrote in message
...
Hi!

Can anybody help me?
I need to get the number of days on a given month-year. (ie Jan-07 = 31
days, etc)

Is there an easy way to get it?

Thnx