Good point. I originally tried 32 without the add, but DateValue didn't like
it. Forgot Feb on my final try.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bondi" wrote in message
oups.com...

Bob Phillips wrote:
=TEXT(DATEVALUE("30-"&A1&"-"&YEAR(TODAY()))+2,"mmmm")

--
HTH

Bob Phillips

Hi,

In case you run in to February you should change 30 to 28 and 2 to 5.

Regards,
Bondi