Auto-populate Dates

[Hydestone]

I have a worksheet which is used to create two week schedules....two weeks - Sunday through Saturday. Is there an easy way to have it populate the days of the month in the cells for the 14 days?

Ie, if I entered 14 in the cell below Sunday - the cells below the days for the next two weeks would auto-populate.

Thoughts on how to do this?

 

[Scott T]

is this what you want? If you want only the day then you can format the cell to show only the day.

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
2	12/31/2017	1/1/2018	1/2/2018	1/3/2018	1/4/2018	1/5/2018	1/6/2018	1/7/2018	1/8/2018	1/9/2018	1/10/2018	1/11/2018	1/12/2018	1/13/2018
Sheet1

Cell Formulas
Range	Formula
B2	=A2+1
C2	=B2+1
D2	=C2+1
E2	=D2+1
F2	=E2+1
G2	=F2+1
H2	=G2+1
I2	=H2+1
J2	=I2+1
K2	=J2+1
L2	=K2+1
M2	=L2+1
N2	=M2+1

 

[Hydestone]

That's great...thanks Scott. I was entering the day of the month without entering the month and year...completely overlooked making them a date then formatting the cell to just show the day!

 

[Scott T]

you're welcome.