Thread: How do I put a Month into a cell and have the cells below change
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Ridgeway Bill Ridgeway is offline
external usenet poster
  
Posts: 268
Default How do I put a Month into a cell and have the cells below change
Assuming the input cell is B5

=DATE(YEAR(B5),MONTH(B5)+1,DAY(B5))

The input cell (as with others) will need to be formatted as mmm and the
date input as 1/7

Regards.

Bill Ridgeway
Computer Solutions

"Cathy in Florida" wrote in
message ...
I would like to enter "July" in an unprotected cell and have the cells
below
automatically generate August, September, October, etc .


--
Cathy
Port Charlotte, FL


Reply With QuoteReply With Quote