Working days

[wildturkey]

Have tried, have failed...

Cell F1 has todays date in it, Cells E1 to B1 should have the preceeding four days but if its a weekend the days are skipped. Ive then formatted to show the day only eg

Tue Wed Thur Fri Mon
Wed Thur Fri Mon Tue
Thur Fri Mon Tue Wed etc etc

Currently have the worlds longest nested IF that still doesnt work

 

[etaf]

have you tried workday()
so
WORKDAY(F1,-4)
i then copied that from E1 to D1 etc , so each cell has 4 days less than next cell and ignores weekends
you can also ad dholidays , so it will ignore those as well

Book7
	A	B	C	D	E	F
1		1/20/21	1/26/21	2/1/21	2/5/21	2/11/21
Sheet1

Cell Formulas
Range	Formula
B1:E1	B1	=WORKDAY(C1,-4)
F1	F1	=TODAY()

 

[Kerryx]

or to show the day =TEXT(WORKDAY(F1,-4),"dddd")
-4 = no.of day from date in this instance 4 dates prior to the date etc.

 

[etaf]

Missed that
OR just format the cell as DDDD
it still has the date , if you need to work later on the actual date but displays the day

Book7
	B	C	D	E	F
1	Wednesday	Tuesday	Monday	Friday	2/11/21
Sheet1

Cell Formulas
Range	Formula
B1:E1	B1	=WORKDAY(C1,-4)
F1	F1	=TODAY()

 

[Kerryx]

or as etaf said formatting the cells works as well
sometimes miss the east things

 

[wildturkey]

or as etaf said formatting the cells works as well
sometimes miss the east things

I was

 

[wildturkey]

I was missing Workday - had tried weekday and that's where I was having issues - many thanks all

 

[etaf]

you are welcome

 

[Kerryx]

no prob