NETWORKDAYS overdue by days

[ExcelRoy]

Evening everyone,

May I please ask for some help

I have the following formula that works out days between L14 (Delivery Date) and TODAY, but when the delivery date expires and runs over the formula shows "overdue"

I have modified it to show how many days over but it showsa negative value, can this be shown as a non-negative number (ie 6 instead of -6)

=IF(L14="","",IF(TODAY()=L14,"Due Today",IF(L14>TODAY(),"Due In "&NETWORKDAYS(TODAY(),L14-1)&" Working Day"&IF(L14-TODAY()>1,"s",""),IF(L14"Greater Thans Sign"TODAY(),"Overdue"&" By "&NETWORKDAYS(TODAY(),L14-1)&" Working Days"))))

many thanks

 

[ExcelRoy]

Sorry just for clarity the formula was

=IF(L14="","",IF(TODAY()=L14,"Due Today",IF(L14>TODAY(),"Due In "&NETWORKDAYS(TODAY(),L14-1)&" Working Day"&IF(L14-TODAY()>1,"s",""),IF(L14 < TODAY(),"Overdue"&" By "&NETWORKDAYS(TODAY(),L14-1)&" Working Days"))))

Thanks

 

[jtakw]

Hi,

Add the ABS function to the formula:

Book1
	L
12	Overdue By 4 Working Days
Sheet48

Cell Formulas
Range	Formula
L12	=IF(L14="","",IF(TODAY()=L14,"Due Today",IF(L14>TODAY(),"Due In "&NETWORKDAYS(TODAY(),L14-1)&" Working Day"&IF(L14-TODAY()>1,"s",""),IF(L14),"Overdue"&" By "&ABS(NETWORKDAYS(TODAY(),L14-1))&" Working Days"))))

 

[ExcelRoy]

Hi jtakw,

Many thanks for the quick reply

So what is the ABS function may I ask?

 

[jtakw]

Hi jtakw,

Many thanks for the quick reply

So what is the ABS function may I ask?

You're welcome.

ABS function: https://support.office.com/en-us/article/abs-function-3420200f-5628-4e8c-99da-c99d7c87713c