# Last Working Day of the Month?

#### pakass12

##### Board Regular
Hi All,

Does anyone know a formula for the last working day of the month (excluding bank hoildays etc).

Also same again, a formula for next Friday.

Thanks

Paul

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### barry houdini

##### MrExcel MVP
Using Analysis ToolPak functions to get last working day of the month where A1 contains your date

=WORKDAY(EOMONTH(A1,0)+1,-1,holidays)

where holidays is a named range containing all holiday dates

For the next Friday after A1

=A1+7-WEEKDAY(A1+1)

If A1 is a Friday formula returns that date

Replies
0
Views
222
Replies
4
Views
172
Replies
1
Views
563
Replies
1
Views
156
Replies
6
Views
405

1,195,833
Messages
6,011,853
Members
441,650
Latest member
ceyoung75

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