Formula for Aging Tickets in Excel

[Jovelllll]

Hi,

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 =IF(TODAY()> B2,TODAY()-AB,0). And as per sample for the 04/01/2020 it included the count for weekends but it shouldn't.

Hoping for your favorable responses. Thank you!

[#2]

@Jovelllll Try this:

=NETWORKDAYS(B2,TODAY())

[#3]

@Riny_van_Eekelen 

Perhaps for outstanding days

=NETWORKDAYS(B2,TODAY())-(WEEKDAY(B2,2)<6)

since

=NETWORKDAYS(TODAY(),TODAY())

returns 1 for workdays and zero for weekends