Adding Workdays to a Formula

Ray Rios

Hi SmartPeople -

I am trying to create a formula that adds "work days" to a date.

Example: I have a "Date Reported" column and a "Date Due" column. The "Date Due" column is a formula based column that should add a specific number of days (either 5, 10, or 20) based on a given priority in the "Priority" column. However, instead of adding "calendar days", I need it to add "workdays".

This is the formula currently using: =IF(Priority3 = "red", [Date Reported]3 + 5, IF(Priority3 = "yellow", [Date Reported]3 + 10, IF(Priority3 = "green", $[Date Due]$2 + 20, IF(Priority3 = "gray", [Date Reported]3 + 20))))

How do I change the formula?

Mike Wilday

You will need to use the following formula to calculate the additional workdays. 

Workday([Date Reported]3, 5)

That will add 5 working days to the Date Reported column (row 3) and return the new date. You will need to replace each of your than statements with that formula.  

I.E. 

=IF(Priority3 = "red", Workday([Date Reported]3, 5), IF(Priority3 = "yellow", Workday([Date Reported]3, 10), IF(Priority3 = "green", Workday($[Date Due]$2 , 20), IF(Priority3 = "gray", Workday([Date Reported]3, 20)))))

That should work for you.