I am looking for a formula to count the business days (excluding public holidays) between two dates. which i have a formula for, the issue is when the second column is blank. if it is blank i would like it to calculate is as if the blank is today. i have googled but i have been unable to find a formula that includes the IF statement (its one or the other)

my current formula is =((NETWORKDAYS(K2,L2,Sheet2!O3:O36)-1)

Sheet 2 is where i have the public holidays

The above formula returns a -30000 number when L columm is blank

Thank you for your help :)

CodePudding user response：

If your current formula works fine then you can use-

=NETWORKDAYS(K2,IF(L2="",TODAY(),L2),Sheet2!O3:O36)-1