Working days and exclude bank holidays

Hello, I have a list of Bank holidays in a tab called Bank Holidays in Column A.

In another tab I have the following formula that looks at a date and calculates the working days however I also need this formula to exclude the list of Bank Holidays.

=IF(O2="","",NETWORKDAYS(O2,(TODAY())))

The formula currently looks at column O, if theres no date then it retuns blank, if theres a date it calculates the working days. I know you can usually add a 3rd arguement to exclude this but I cant work out where it sits in the formula.

ALSO

I have another formula on another sheet =IF(D2="","",D2+7) that needs to look at the same Bank Holiday list and exclude them from the result.


Can you advise what the correct formula is to exclude the dates?

Thanks in Advance.

Nath'

Like this:

=IF(O2="","",NETWORKDAYS(O2,TODAY(),range_with_dates))

where range_with_dates is the range containing the bank holiday dates (e.g. $A$1:$A$5).

=IF(O2="","",NETWORKDAYS(O2,TODAY(),range))

where range is the range of your list of holidays

Snap, Glenn!

Top o' the mornin' to ya!!!

It's sunny here.... Cold, but sunny!! Woo Hoo..

It's sunny here ... Windy, but sunny! Hehehe ...

=IF(E2="","",WORKDAY(E2,7,range)) again, where range = list of hols...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.