Well I've rarely heard of a formula described as 'Cute' but there we are!!.
Thanks for the feedback.

Mike

"Narnimar" wrote:

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.