# of days in month
Thanks! It worked - I wanted to know how it works. I broke up the formula
and get the parts. When I put it together - DATE(YEAR(A1),MONTH(A1)+1,0) - I
get the date - 7/31/2001 and then day (7/31/2001) - 31. Why add 1 to the
month?
Thanks a ton!
"PCLIVE" wrote:
Where A1 contains a date:
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
"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.
|