Formula for Aging Tickets in Excel

Question

Hi,&nbsp;I'd like to seek for a help/assistance with my concern. I'm planning to make a report in Excel. Basically I want to get the code/formula on how will I total the days outstanding from the date it was created but what I want to get to is to exclude the weekends. I'm currently using the formula&nbsp;=IF(TODAY()&gt; B2,TODAY()-AB,0). And as per sample for the 04/01/2020 it included the count for weekends but it shouldn't.&nbsp;&nbsp;Hoping for your favorable responses. Thank you!

riny_van_eekelen · Answer

Jovelllll&nbsp;Try this:=NETWORKDAYS(B2,TODAY())&nbsp;

sergeibaklan · Answer

Riny_van_Eekelen&nbsp;
Perhaps for outstanding days
=NETWORKDAYS(B2,TODAY())-(WEEKDAY(B2,2)&lt;6)
since
=NETWORKDAYS(TODAY(),TODAY())
returns 1 for workdays and zero for weekends

Forum Discussion

Formula for Aging Tickets in Excel

2 Replies

Resources