Turn average working days to projected date using WORKDAY()
The basic ask is to calculate a projected due date based on historical data and duration that a certain task takes. So if x, y, and z parameters are checked, it will find the average amount of time (from a different sheet) that those parameters take and then calculate a suggested due date.
I want to use WORKDAY(), but am receiving an error message that reads #INVALID DATA TYPE.
So in the column titled [Average Days] I'll have the cell that calculates the average time and outputs a value of working days, let's say 20. In the cell next to it, I type =WORKDAY(TODAY(),[Column A]1) and receive an error message. But when I try to just hardcode it - =WORKDAY(TODAY(),20), I get a projected date. So there must be something wrong with referencing a calculated/formula-ed cell? Is there a workaround or has anyone seen anything similar and found a solution?
Help Article Resources
Check out the Formula Handbook template!