Totally stumped

[jmmckillen]

I am trying to populate cells A2 thru G7 with the dates of the current week based on today's date in cell A1. Can anyone help? I already know how to get the days of the week. Thx

 

[jmmckillen]

That should be cells A2 thru G2. Sorry.

 

[Fluff]

Do you want the dates starting from Sunday, Monday or some other day?

 

[Sufiyan97]

Try

Book1
	A	B	C	D	E	F	G	H	I
1	Starting Day	12/17/2021
2	Monday	12/13/2021	12/14/2021	12/15/2021	12/16/2021	12/17/2021	12/18/2021	12/19/2021
3	Sunday	12/12/2021	12/13/2021	12/14/2021	12/15/2021	12/16/2021	12/17/2021	12/18/2021
4
Sheet4

Cell Formulas
Range	Formula
B2:H2	B2	=$B$1-WEEKDAY($B$1,2)+COLUMNS($B$2:B2)
B3:H3	B3	=$B$1-WEEKDAY($B$1,1)+COLUMNS($B$2:B2)

 

[jmmckillen]

Do you want the dates starting from Sunday, Monday or some other day?

Worked like a charm. I used the formula starting on a Sunday. Thank you!

 

[Sufiyan97]

You're Welcome.
Glad we could help!