Highlight Dates in the Next 30 Days
Highlight Dates in the Next 30 Days
Use conditional formatting or Create an IF formula (perhaps in cell below or adjacent) that would put "w/in 30days" if <=30 days or a Blank cell (or 'Not 30D").
Really, how hard could it be to copy and/or paste a sample, if you really want assistance?