Hi Narnimar,

Here's another way:
=DATE(YEAR(A1),MONTH(A1)+1,0)-DATE(YEAR(A1),MONTH(A1),0)

--
Cheers
macropod
[MVP - Microsoft Word]


"Narnimar" wrote in message ...
What is the formula to return the # of days in that month for a randomly
selected date? Thanks for the help.