Hello,
I am using an excel sheet to track casework and using conditional formatting to show when tasks are overdue (they have missed their 5 day deadline). I am using the following formula:
=AND(NETWORKDAYS(D3,TODAY())>5,D3<>"")
I would really like to add in a custom list of holidays so that they aren't counted but I have tried creating names ranges and adding them into the formula (see below) but it doesn't register the dates:
=AND(NETWORKDAYS(D3,TODAY,Holidays33)>5,D3<>"")
If anyone could help explain what the best method for getting a list of holidays built in, that would be super helpful!
I am using an excel sheet to track casework and using conditional formatting to show when tasks are overdue (they have missed their 5 day deadline). I am using the following formula:
=AND(NETWORKDAYS(D3,TODAY())>5,D3<>"")
I would really like to add in a custom list of holidays so that they aren't counted but I have tried creating names ranges and adding them into the formula (see below) but it doesn't register the dates:
=AND(NETWORKDAYS(D3,TODAY,Holidays33)>5,D3<>"")
If anyone could help explain what the best method for getting a list of holidays built in, that would be super helpful!