How do I put a Month into a cell and have the cells below change
 

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

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