Date Format used in a formula.

[itsgrady]

I can get the date to display a single day through format cell—-

11/14/22 = Monday

—but I can’t use “Monday” in a formula.

I have a form that has Monday through Sunday Summary. I put the current date on the form each day.

I need to date the columns each day based on the date I enter.

Date I enter:
11/15/22 Tuesday

I need to return this in each column:
Monday 11/14/22
Tuesday 11/15/22
Wednesday 11/16/22
Thursday 11/17/22
Friday 11/18/22
Saturday 11/19/22
Sunday 11/20/22

I figure the first column is all I need to enter the formula in, then take that cell and add 1 day for the rest of the cells.

 

[6StringJazzer]

It would help if you showed the actual sheet layout.

Generically:

Enter the start date in the first cell
In the second cell use

=A1+1

where A1 is the first cell
Copy that formula to the right for the other cells
Select all cells and use custom format

Dddd mm/dd/yy

$scratch.xlsm
	A	B	C	D	E	F
1	Tuesday 11/15/22	Wednesday 11/16/22	Thursday 11/17/22	Friday 11/18/22	Saturday 11/19/22	Sunday 11/20/22
Sheet2

Cell Formulas
Range	Formula
B1:F1	B1	=A1+1

 

[itsgrady]

It would help if you showed the actual sheet layout.

Generically:

Enter the start date in the first cell
In the second cell use

=A1+1

where A1 is the first cell
Copy that formula to the right for the other cells
Select all cells and use custom format

Dddd mm/dd/yy

$scratch.xlsm
	A	B	C	D	E	F
1	Tuesday 11/15/22	Wednesday 11/16/22	Thursday 11/17/22	Friday 11/18/22	Saturday 11/19/22	Sunday 11/20/22
Sheet2

Cell Formulas
Range	Formula
B1:F1	B1	=A1+1

Thanks for the reply. After trail and error I found a good solution since I am going to update the date each day:

=ifs(TEXT((D17),”ddd”)=“Sun”,D17-6,(TEXT((D17),”ddd”)=“Sat”,D17-5,(TEXT((D17),”ddd”)=“Fri”,D17-4,(TEXT((D17),”ddd”)=“Thu”,D17-3,
(TEXT((D17),”ddd”)=“Wed”,D17-2,(TEXT((D17),”ddd”)=“Tue”,D17-1,(TEXT((D17),”ddd”)=“Mon”,D17,

 

[6StringJazzer]

It's not clear what you want to do. But the formula you showed here is rather convoluted. I suggest you do it more concisely using the WEEKDAY function:

=D17-WEEKDAY(D17,3)

 

[itsgrady]

It's not clear what you want to do. But the formula you showed here is rather convoluted. I suggest you do it more concisely using the WEEKDAY function:

=D17-WEEKDAY(D17,3)

Thanks for your help in this solution. Worked very well with only a short code.