Thread: Months
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 174
Default Months

If you enter the month as text, e.g. December in cell A1 then this formula
will return next month

=TEXT(("1 "&A1)+31,"mmmm")

"Pasty" wrote:

How do I make it so that if someone inputs a month for an action that it
automatically makes the next column (month of review) have the value of the
month after e.g. for an action in March it will need to be review in April