One way


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


format as general



--


Regards,


Peo Sjoblom



"Jman" wrote in message
...
I want to know how many days are in a month.
In A1 I have a date ex. 3/3/08.
In B1 i want to give me total days in that month.

Is there a formula for that.