Drive Status Indicators on [End Date] vs. Today, considering only Workdays
I use a formula below to show red, yellow, green and blue based on less than 100% completion when end date is in X days.
- If complete, blue.
- If incomplete/ends tomorrow, red.
- If incomplete/ends in two days, yellow.
- If incomplete/ends in three or more days, green.
My program does not count weekends. How can my formula consider only workdays?
# End Status
[% Complete]@row = 1, "Blue",
IF(AND([% Complete]@row < 1, [Revised End Date]@row <= TODAY(1) ), "Red",
IF(AND([% Complete]@row < 1, [Revised End Date]@row <= TODAY(2) ), "Yellow",