specific days of the week

[njosh]

kindly help date problem; using start date(03/13/2013), help with formula to autofil first row as weekdays, second row as week dates; this is for three months such that change in start date has corresponding change automatically on days, dates following

start date (03/13/2021)	monday	tuesday	wednesday	thursday	friday	monday
	03/01/2021	03/02/2021	03/03/02021	03/04/2021	03/05/2021	03/08/2021

thank you

 

[etaf]

how about

Book1
	A	B	C	D	E	F	G	H	I
1	start date 13/03/2021	Monday	Tuesday	Wednesday	Thursday	Friday	Monday	Tuesday	Wednesday
2		3/15/21	3/16/21	3/17/21	3/18/21	3/19/21	3/22/21	3/23/21	3/24/21
Sheet2

Cell Formulas
Range	Formula
B1:I1	B1	=B2
B2	B2	=WORKDAY(RIGHT(A1,10)*1,1)
C2:I2	C2	=WORKDAY(B2,1)

 

[njosh]

thanks brother, kindly check for two weekdays and a weekend as stated below; monday, thursday, saturday

13/03/2021	monday	thursday	saturday	monday	thursday	saturday

then again, could you explain workday function
=WORKDAY(RIGHT(A1,10)*1,1)
my thinking is, if we remove "start date" from the cell just like this table, can we say workday(a1) without the right function

 

[Dave Patton]

N.B. all the cells are Dates. A4 and A6 are custom formatted including the text "Start Date".
You can review Excel's Help for the functions.

Workday.xlsm
	A	B	C	D	E	F	G
3
4	Start Date 13-Mar-21	Mon 15-Mar-21	Tue 16-Mar-21	Wed 17-Mar-21	Thu 18-Mar-21	Fri 19-Mar-21	Mon 22-Mar-21
5
6	Start Date 13-Mar-21	Mon 15-Mar-21	Thu 18-Mar-21	Sat 20-Mar-21	Mon 22-Mar-21	Thu 25-Mar-21	Sat 27-Mar-21
7
2b

Cell Formulas
Range	Formula
B4:G4	B4	=WORKDAY(A4,1)
B6:G6	B6	=WORKDAY.INTL(A6,1,"0110101")