Determine Working Days between two dates and if it's valid

[treeleaf20]

I have a column for a start date (E2) and a finish date (F2). I also have a date at the top of every column that is the week starting on Monday (O1).

I'm trying to write a formula to determine if the date in O1 is in between the start and finish dates and if it is, how many working days are between the two dates until the week that ends on the top date.

A working example is this.

Start Date: 12/18/2017 (E2)
Finish Date: 12/27/2017 (F2)

Column heading date (O1) is 12/18/2017, I would expect O2 to give me 5. Column heading date (12/25/2017) P1, I would expect P2 to have a value of 3 because the finish date is the 27th and there is only 3 working days between the 25th and the 27th.

Is this possible to do?

Thanks

 

[Marcelo Branco]

Maybe...

O2 copied across
=MAX(0,NETWORKDAYS(MAX($E$2,O1),MIN($F$2,O1+6)))

M.

 

[treeleaf20]

This worked perfectly. Thank you very much.

 

[Marcelo Branco]

You are welcome. Glad to help.

M.