Auto Fill Week and Date From Single Cell

[ScoutLaser]

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 sets the date for a series of other cells. A1 reads: 2/1/2024

I want this to then autofill a series of cells that are not adjacent to the initial:

H2 should read "02/01"

I2 as "02/02"

J2 as "02/03" 

...and so on. 

How can I make this happen without having to edit the starting date in multiple places?

Thanks!

[#2 · Accepted solution]

@ScoutLaser 

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

[#3]

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!

[#4]

@ScoutLaser 

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.