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'
Bookmarks