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

This might be a stupid question.

i have a cell (A1), with a month's name: "April"
How do i use a formula so cell B1 will show "May"

and when i change A1 to "June" Cell B1 will show "July"?

Basically a calulation but without a full date

Thanks
Jared