I use this formula to notify me when something has went past its deadline:
=IF(AND(LEN(H558)<>0,H558>K558),"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.
Bookmarks