Including only NETWORKDAYS in Aging

Cristina Parker

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

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

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

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.