symbol column to add workdays in formula

David Friesen

Hi,

I want to create a RYG status if a date is late.  If it is one workday late it is "Yellow", if it is 2 days late it is "Red" and all other are "Green".  The End Date is the due date.  The underlined formula will show 2 calendar days but I need workdays/vacation included.  Any ideas on how to resolve? 

=IF(AND(ISBLANK(completion645), [End Date]645 < TODAY()), "Red", IF(completion645 <= [End Date]645, "Green", IF(completion645 - [End Date]645 < 2, "Yellow", "Red")))  

Thank you.

Shaine Greenwood

Hi David,

Try using NETWORKDAY in your formula:

...IF(NETWORKDAY(completion645, [End Date]645) < 2, "Yellow"...

More on this here: https://help.smartsheet.com/function/networkday