This is very cute. Thanks a lot.

"Mike H" wrote:

Maybe a bit shorter

=32-DAY(A1-DAY(A1)+32)

Format as general

Mike

"Narnimar" wrote:

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