Forum Discussion
Removing Weekends in my if formula
I am trying to enter an if formula which takes into account only working days, so non-weekends and holidays. My formula is: =IF(O66-M66 <=3, "Yes", "No") I want my date to show Yes/No if we met a de...
Create a list of public holidays in a column, and name this range Holidays.
(Select the range, click in the name/address box on the left hand side of the formula bar, type Holidays and press Enter)
Change the formula to
=IF(NETWORKDAYS.INTL(M66, O66, 1, Holidays)<=4, "Yes", "No")
(I used 4 instead of 3 because NETWORKDAYS.INTL includes both the start date and end date in the count)