Number of Weeks between 2 Dates

[Madball]

Hi,

I want to be able to display the number of working weeks between 2 dates that also deduct the UK Bank holidays. How would I go about creating this formula?

I presume I would use the NETWORKDAYS formula and divide it by 5, but I cannot remember how to get it to deduct the bank holidays.

Thanks in Advance

[NBVC]

but I cannot remember how to get it to deduct the bank holidays.

You need to create a list on your sheet somewhere of the bank holidays and then reference that list in your Networkdays() formula... it would be the 3rd argument in the list.

e.g. =Networkdays(start_date,end_date,holidays)

[Madball]

Ah yes, I remember now thanks a lot So just do that formula you've just posted and then divide by 5 to get the working weeks?

[NBVC]

I think so.... do some manual tests to make sure....

[Madball]

Thanks for the help, after some testing it does seem to work correctly

=NETWORKDAYS(Start_Date,End_DATE,Holidays)/5