Forum Discussion
Formula for Aging Tickets in Excel
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...
Perhaps for outstanding days
=NETWORKDAYS(B2,TODAY())-(WEEKDAY(B2,2)<6)since
=NETWORKDAYS(TODAY(),TODAY())returns 1 for workdays and zero for weekends