| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
