Hi Team
I need some help. No of days
No of days : Column FU : IF column FS8 has a date then FU must show the number of days from FS8-N8 however if FS8 = blank then look into FT8 to see if if is > than Today & N8 , if so then FT8-N8
Delivery status : Column FV : If column FS8 has a date then DIFFERENECE BETWEEN FS8 - N8 NEEDS TO SAY "Delivered late" , Delivered Early , IF NOT THEN LOOK INTO column FT8 - N8 TO GIVE A STATUS OF Delivered late" , Delivered Early.
I need some help. No of days
No of days : Column FU : IF column FS8 has a date then FU must show the number of days from FS8-N8 however if FS8 = blank then look into FT8 to see if if is > than Today & N8 , if so then FT8-N8
Delivery status : Column FV : If column FS8 has a date then DIFFERENECE BETWEEN FS8 - N8 NEEDS TO SAY "Delivered late" , Delivered Early , IF NOT THEN LOOK INTO column FT8 - N8 TO GIVE A STATUS OF Delivered late" , Delivered Early.