Forum Discussion
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/...
Do you mean
=IF(D4<=(TODAY()+$G$3),"<<<","")
?
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.
I only need it to mark upcoming dates, if that makes sense.
If only upcoming days when like
assuming today is Feb 05. Correct?
JakeZimmerman , for such data you may apply conditional formatting rule
with formula
=($D4<(TODAY()+$G$4))*($D4>TODAY())
and applying custom format to dates as
mm/dd/yy"<<<"
Or use only mark in next column with formula
=IF(($D4<(TODAY()+$G$4))*($D4>TODAY()),"<<<","")
File is attached