NETWORKDAYS.INTL

[SMB1982]

I have this formula for tracking leaves: NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]). Which works great for my Monday - Friday people.

The trouble I'm having is with my employees who work a swing shift and their days off are split. (for example in one week they work Monday, Tuesday, Friday and Saturday. Sunday, Wednesday and Thursday are their days off.)

Is there a work around? Or should I enter as no weekends and just add each day individually? Which I would ideally like to avoid when someone is on a block leave.

 

[Fluff]

Hi & welcome to MrExcel.
You can use

NETWORKDAYS.INTL(start_date, end_date, "0011001", [holidays])

which will only return dates for Monday, Tuesday, Friday or Saturday.

 

[SMB1982]

TY!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[SMB1982]

You're welcome & thanks for the feedback.

I have a follow up question, if that's ok. For employees who work a two week rotating schedule, is it possible to enter in two weeks?

 

[Fluff]

No, the dtring of 1s & 0s has to be 7 digits long.

 

[SMB1982]

Appreciate the response, thanks again!

 

[Fluff]

My pleasure.