symbol column to add workdays in formula

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.

Find more posts tagged with

Formulas

Project Management

Account and User Management

Comments

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