Thread: Deadline Notice
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roy.okinawa
 
Posts: n/a
Default Deadline Notice

I use this formula to notify me when something has went past its deadline:

=IF(AND(LEN(H558)<0,H558K558),"Past TAT","")

I would like it modified to alert me when the accumulated days in "H" are 5
days before the set days in "K".

Formula + "5 days before TAT".

Please help.