Forum Discussion
JakeZimmerman
Feb 04, 2019Copper Contributor
Trouble with my Date Alert Fomula
Good Afternoon. I'm trying to create a formula that will alert me in an excel sheet when a date is 30 days or sooner. In my sheet, I have I have several date ranges such as : 2/5/19 3/5/...
SergeiBaklan
Feb 04, 2019Diamond Contributor
Do you mean
=IF(D4<=(TODAY()+$G$3),"<<<","")
?
- JakeZimmermanFeb 04, 2019Copper Contributor
This unfortunately does prior date range + or -. So example
2/3/19
2/4/19
/2/5/19
Where $G$3 = 4 it would mark all 3 days with that range.
- JakeZimmermanFeb 04, 2019Copper Contributor
I only need it to mark upcoming dates, if that makes sense.
- SergeiBaklanFeb 04, 2019Diamond Contributor
If only upcoming days when like
assuming today is Feb 05. Correct?