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, ""))
Best Answer
-
I had to update it to NETWORKDAYS but then it worked. Thank you Ryan!
=IF(Status@row <> "Completed", NETWORKDAYS([Created Date]@row, TODAY()), "")
Answers
-
I don't think the Created Date system field really is a date field. Or a compatible date anyway.
You might consider running a date capture automation to fill in the Created Date and set the column type to date. It should work as expected.
-
@Samantha Gordon You were so close! try this...
=IF(Status@row <> "Completed", NETDAYS([Created Date]@row, TODAY()), "")
-
I had to update it to NETWORKDAYS but then it worked. Thank you Ryan!
=IF(Status@row <> "Completed", NETWORKDAYS([Created Date]@row, TODAY()), "")
Help Article Resources
Categories
Check out the Formula Handbook template!