Adding Holidays between two dates

Hi,

I have a formula to be able to work out the number of Mondays, Tuesdays and so on through to Sunday in between certain dates but i'm looking for a way to be able to holidays off a certain day so if a holiday happens to fall on a monday it would show as let say 5 mondays instead of 6, and i'd need it to work for each day between Sunday to Saturday.

Have uploaded file

Thanks
Donald

Hi AliGW,

While that sort of works i need it to just work out how many mondays Tuesdays etc then if a public holiday happens to fall on a
tuesday it will only take it off a tuesday and not the others from what i can tell NETWORKDAYS.INTL function won't allow me to do that.

Donald

Originally Posted by dharvey078

i can tell NETWORKDAYS.INTL function won't allow me to do that.

You can use NETWORKDAYS.INTL function.

Sunday:

=NETWORKDAYS.INTL($A$2,$B$2,"1111110",$B$2)

Monday:

=NETWORKDAYS.INTL($A$2,$B$2,"0111111",$B$2)

...

Originally Posted by Phuocam

You can use NETWORKDAYS.INTL function.

Sunday:

=NETWORKDAYS.INTL($A$2,$B$2,"1111110",$B$2)

Monday:

=NETWORKDAYS.INTL($A$2,$B$2,"0111111",$B$2)

...

Thankyou very much for this formula it has worked a treat.

Donald