Forum Discussion

Copper Contributor

Feb 04, 2019

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/...

Formulas and Functions

JakeZimmerman

Copper Contributor

Feb 04, 2019

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.

JakeZimmerman

Copper Contributor

Feb 04, 2019

I only need it to mark upcoming dates, if that makes sense.

SergeiBaklan
Diamond Contributor
Feb 04, 2019
If only upcoming days when like

assuming today is Feb 05. Correct?
- SergeiBaklan
  Diamond Contributor
  Feb 04, 2019
  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
  DateAlert.xlsx10 KB
- JakeZimmerman
  Copper Contributor
  Feb 04, 2019
  Exactly,
  
  So in my spreadsheet I have a column with dates in it, and to the right of the column I need a way to mark if those dates are coming up in the next X amount of days, but with my formula I made, it only does exact dates. I tried to use <= with it to do 3 days or less, but then it marks 3 days prior to today as well.