# What working day of the month a particular date is?

#### benposaner

##### New Member
Hi

Sure it's simple but can I use a formula to workout what working day of the month a particular date is?
Assuming Working week is Mon-Fri and Bank holidays are excluded.

For example today 7th January is 4th working day of the month. (1st is Bank Hol and 2nd & 3rd are weekend)
So 1st working day would be have been the 4th Jan, etc.

So the formula should return working day 14 for 21st Jan 2021

I've tried using WORKDAY.INTL, to also exclude weekends and Holidays, but can't figure out how use the (start_date, days) in the formula to tell me what the corresponding working day of the month would be.

Any help would be great.
Thanks.
Ben

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### etaf

##### Well-known Member
networkday()

=NETWORKDAYS(DATEVALUE(1&"/"&MONTH(A1)&"/"&YEAR(A1)),A1,[Holidays])

DATEVALUE(1&"/"&MONTH(A1)&"/"&YEAR(A1))
Will pickup the first of the month

#### benposaner

##### New Member
That's great, thanks.

you are welcome

#### Dave Patton

##### Well-known Member
alternatives

T202101a.xlsm
ABC
17-Jan-2144
221-Jan-211414
5a
Cell Formulas
RangeFormula
B1:B2B1=NETWORKDAYS(EOMONTH(A1,-1)+1,A1,Holidays)
C1:C2C1=NETWORKDAYS.INTL(EOMONTH(A1,-1)+1,A1,1,Holidays)
Named Ranges
NameRefers ToCells
'5a'!Holidays='5a'!\$M\$1:\$M\$7B1:C2

#### benposaner

##### New Member
Many thanks, these will be great!

Replies
2
Views
141
Replies
1
Views
117
Replies
18
Views
496
Replies
0
Views
120
Replies
5
Views
210

1,127,623
Messages
5,625,938
Members
416,143
Latest member
JoyceMB

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