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

C

Cathy in Florida

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

Bill Ridgeway

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
 
Top