# Working days

#### wildturkey

##### Board Regular
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

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### etaf

##### Well-known Member
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

Cell Formulas
RangeFormula
B1:E1B1=WORKDAY(C1,-4)
F1F1=TODAY()

#### Kerryx

##### Board Regular
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

##### Well-known Member
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

Cell Formulas
RangeFormula
B1:E1B1=WORKDAY(C1,-4)
F1F1=TODAY()

#### Kerryx

##### Board Regular

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

#### wildturkey

##### Board Regular
or as etaf said formatting the cells works as well
sometimes miss the east things
I was

#### wildturkey

##### Board Regular

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

you are welcome

#### Kerryx

##### Board Regular
no prob

Replies
1
Views
185
Replies
3
Views
188
Replies
1
Views
140
Replies
8
Views
170
Replies
8
Views
122

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,399
Messages
5,769,849
Members
425,574
Latest member
grimeslisa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back