Business days since line created
I need to calculate workdays since date created if a line is NOT "completed". So if a line is still not completed, I want to know the aging date since line was created.
I have a formula to calculate ho many days have passed since a line was created if not completed, but I am lost trying to only pull workdays from the created date until today.
=IF(Status@row <> "Completed", TODAY() - [Created Date]@row, "")
I am receiving an error with the below formulas:
=IF([Status]<> "Completed", NETWORKDAY(TODAY() - [Created Date]))
=IF(Status@row <> "Completed", NETDAYS((today) - [Created Date]@row, ""))
Help Article Resources
Check out the Formula Handbook template!