Hi Guys,

I have a spreadsheet that I use to work out my Annual leave at work. the function NETWORKDAYS works great and I have a seperate sheet that I have all the bank holidays on so that it calculates my days off correctly. This works fine.

What I wanted to know in my office we have certain days that are compulsory. Is it possible to use the NETWORKDAYS function to check to see if your dates clash with the compulsory dates?

For example. If I wanted to book off the 4th Feb to 8th Feb but the 6th & 7th of Feb are compulsary. Is it possible for my spreadsheet to me let know that 2 days in my range are compulsory?

Thanks in advance.