If some date in that month is given in cell A1

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


Steve


"Marek" wrote in message
...
Hi,

Does anyone know how to work out how many days a month has? Something
that
can accomodate leap years as well. So, if it's Feb 2005 it's 28 days. If
it
were Feb 2004 it would be 29 days.


--
Many thanks in advance for any assistance