Auto populate months into cells

[Hydestone]

I have 12 cells E8:P8 that contain months, January, February...

I'd like to type in a month in cell E8 and have the remaining months auto-populate. If E8 is June...F8 would be July...P8 would be May.

Is there an easy way to do this without macros?

 

[Joe4]

First, put the following Custom Format on the range E8:P8:
mmmm

Then, in cell E8 enter the month you want to show first as a date, specifically the first day on the month i.e. enter 1/1 for January.
Then in cell F8, enter the following formula:

=EDATE(E8,1)

and copy that formula across all the way to cell P8.

 

[Hydestone]

That is great Joe, thanks!

Two quick follow up questions

1. Can that formula be modified, so that if the contents in E8 are deleted, nothing populates into cells F8:P8? Do I need an ISBLANK(E8,"",(EDATE(E8,1))) or something similar?
2. I would like cells E16:P16 to have the same information in them that is in E8:P8. So if the cells in row 8 are empty, so are the cells in row 16. Right now the cells in 16 are showing "0" if the cells in 8 are blank.

Thanks in advance.

 

[Joe4]

1. Yes, you could use a formula, but yours is not quite right. To follow the way you were thinking, the formula should look something like this:

=IF(ISBLANK($E8),"",(EDATE(E8,1)))

2. Should the formulas in row 16 be looking at cell E16 or E8?

If E16, either copy the formula down from row 8 (the rows should adjust automatically).
If you are typing it manually instead of copying, you need to replace the row number references of 8 to 16, i.e.

=IF(ISBLANK($E16),"",(EDATE(E16,1)))