Business days since line created

Samantha Gordon

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, ""))

Samantha Gordon

I had to update it to NETWORKDAYS but then it worked. Thank you Ryan!

=IF(Status@row <> "Completed", NETWORKDAYS([Created Date]@row, TODAY()), "")

Earl Tessmer

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.

Ryan Sides

@Samantha Gordon You were so close! try this...

=IF(Status@row <> "Completed", NETDAYS([Created Date]@row, TODAY()), "")

Samantha Gordon

I had to update it to NETWORKDAYS but then it worked. Thank you Ryan!

=IF(Status@row <> "Completed", NETWORKDAYS([Created Date]@row, TODAY()), "")