Including only NETWORKDAYS in Aging

Cristina Parker · 04/21/21

Looking for some help finding the aging for ticket resolution, in workdays. I can't seem to find a workable solution to add to my working formula below, which finds the count between either Today's date and the Created date OR Created and Closed dates.

Any tips? Thank you!

=IF(Closed@row = "", TODAY() - Created@row, Closed@row - Created@row)

Cody Holmes · 04/21/21

The NETWORKDAY() and NETWORKDAYS() functions are what you are looking for. The first will add one to the calculation if the start date (or today in your case) falls on a weekend. The second does not. I always find the second function to be more useful. I have implemented the NETWORKDAYS() into your formula. See below:

=IF(Closed@row = "", NETWORKDAYS(Created@row, TODAY()), NETWORKDAYS(Created@row, Closed@row))

If this resolves your question, accept my solution as an answer and give me a vote up! Let me know if that works or not.

Cody Holmes · 04/21/21

The NETWORKDAY() and NETWORKDAYS() functions are what you are looking for. The first will add one to the calculation if the start date (or today in your case) falls on a weekend. The second does not. I always find the second function to be more useful. I have implemented the NETWORKDAYS() into your formula. See below:

=IF(Closed@row = "", NETWORKDAYS(Created@row, TODAY()), NETWORKDAYS(Created@row, Closed@row))

If this resolves your question, accept my solution as an answer and give me a vote up! Let me know if that works or not.

Cristina Parker · 04/21/21

Thanks @Cody Holmes - I was able to copy/paste directly from your solution and finally no errors! What a relief. Looks like I had placed NETWORKDAYS into the wrong spots.

Including only NETWORKDAYS in Aging

Best Answer

Answers

Help Article Resources

Categories