Thread: how to calculate a month without the full date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bondi
 
Posts: n/a
Default how to calculate a month without the full date?

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

Reply With QuoteReply With Quote