# of days in month
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
with a date in A1 and the cell with the above formatted as general it will
do what you want.
--
Regards,
Peo Sjoblom
"dipsy" wrote in message
...
I know the month and want a formula that will tell me number of days in the
month. For example, April would be 30 days and May would be 31 days.
|