If the tickler must go in effect from the 45th day on, use:
=IF(TODAY()-B2<=45,"Time To Call","")
But then, how do I reset the formula when I put in a new date for another 45 days?
If I put in a new date, "Time To Call" doesn't go away like I want it to ---
Also, I want "Time To Call" to pop up in yellow or green. How do I add to the formula?
Thanks so much.
=IF(TODAY()-B2<=45,"Time To Call","")
But then, how do I reset the formula when I put in a new date for another 45 days?
If I put in a new date, "Time To Call" doesn't go away like I want it to ---
Also, I want "Time To Call" to pop up in yellow or green. How do I add to the formula?
Thanks so much.