Need Formula to take todays date and fill dates for week days.

[x8xviperx6x]

I've been looking for an answer for quite some time now without any luck. It has been difficult to word so even more difficult to find an answer.


What i'm trying to do is have excel take todays date in cell A1 =date()

In cells a2:g2 it is respectively Sunday - Monday I need a formula to have it auto populate cells a3:g3 with the correct dates dependent of the current date in cell A1.

For example:

A1 = 08/23/2018 <--- =date()

a2 = Sunday, b2 = Monday, c2 = Tuesday, d2 = Wednesday, e2 = Thursday, f2 = Friday, g2 = Saturday <---- doesn't change
a3= 08/19/2018, b3 = 08/20/2018, c3 = 08/21/2018, d3 = 08/22/2018, e3 = 08/23/2018, f3 = 08/24/2018, g3 = 08/25/2018 <--- auto-populated.


Any help would be greatly appreciated.
Thanks!

 

[mrshl9898]

I'd just have =TODAY()-WEEKDAY(TODAY())+1 in A3, then B3 across is just =A2+1

 

[x8xviperx6x]

The Problem with that formula is that A1 is a user inputting a specified date which changes per user. Once they input a date a3:g3 should auto populate.

 

[jtakw]

Hi,

Does this do what you want.

Book1
	A	B	C	D	E	F	G
1	8/24/2018
2	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
3	8/19/2018	8/20/2018	8/21/2018	8/22/2018	8/23/2018	8/24/2018	8/25/2018
Sheet197

Cell Formulas
Range	Formula
A3	=$A1-WEEKDAY($A1,1)+COLUMN()

A3 formula copied across.

 

[x8xviperx6x]

I didn't even think of the column formula, this is what I was looking for! Thanks a lot for the help worked great!

 

[jtakw]

You're welcome, glad it worked for you.