Forum Discussion
Solved
Auto Fill Week and Date From Single Cell
Hello, I've been trying to set up a formula that auto-populates cells with days of the week and a second cell with mm/dd format all based on a single starting date. For example: Cell A1...
In H2:
=SEQUENCE(1, 29, A1)
This will spill to 29 columns (if you want more or fewer dates, change the number 29 in the formula)
Select the spill area and format it as mm/dd
In H2:
=SEQUENCE(1, 29, A1)
This will spill to 29 columns (if you want more or fewer dates, change the number 29 in the formula)
Select the spill area and format it as mm/dd
Hi HansVogelaar,
Thanks for that. Is there a reason that this would not work in a Table set up with column headers? It seems to work in other cells, but not there. I keep getting a readout showing an incorrect date.
Thanks!
Dynamic array formulas don't work in tables.
Instead, enter the following formula in H2:
=$A$1+COLUMN(H2)-COLUMN($H2)
If necessary, format H2 as a date.
Fill to the right.
