Excel - Calculate working days between 2 dates, monthly.

[CottonSquad]

Hi, I?m trying to calculate periods of absence between 2 dates, on a monthly basis, and need only working days.

Please see attached spreadsheet.

Many thanks

[WideBoyDixon]

H9 formula:

=MAX(NETWORKDAYS(MAX($F9,H$3),MIN($G9,H$4),$C$3:$C$12),0)

Copy across and down.

WBD

[MarvinP]

Hi CottonSquad and welcome to the forum,

I think you are looking for some form of the Workday formula. If you have Saturday and Sunday and non-workdays then the attached might be what you want. I've used the maximum of the start date and month date and minimum of end dates for the calculations that looks like this:

=IF(NETWORKDAYS(MAX($F9,H$3),MIN($G9,H$4),$C$3:$C$12)<0,0,NETWORKDAYS(MAX($F9,H$3),MIN($G9,H$4),$C$3:$C$12)) 

Workday Absence per month .xlsx

If I've missed the entire question then please keep asking.

[CottonSquad]

Thanks so much, and so quick! Game changer for me!