Excel Highlight question

0
                Current Date 22-04-2017           22-04-2017 03-05-2017 14-05-2017 25-05-2017 05-06-2017 23-04-2017 04-05-2017 15-05-2017 26-05-2017 06-06-2017 24-04-2017 05-05-2017 16-05-2017 27-05-2017 07-06-2017 25-04-2017 06-05-2017 17-05-2017 28-05-2017 08-06-2017 26-04-2017 07-05-2017 18-05-2017 29-05-2017 09-06-2017 27-04-2017 08-05-2017 19-05-2017 30-05-2017 10-06-2017 28-04-2017 09-05-2017 20-05-2017 31-05-2017 11-06-2017 29-04-2017 10-05-2017 21-05-2017 01-06-2017 12-06-2017 30-04-2017 11-05-2017 22-05-2017 02-06-2017 13-06-2017 01-05-2017 12-05-2017 23-05-2017 03-06-2017 14-06-2017 02-05-2017 13-05-2017 24-05-2017 04-06-2017 15-06-2017          

Highlight Dates in the Next 30 Days

Answer
Discuss

Discussion

I am just as lazy as you are, lol:
Variatus (rep: 1815) Oct 5, '17 at 3:49 am
Dude.... until you provide a sample workbook or a detailed explanation of what you need, all I'm gonna say is "conditional formatting + date functions"
don (rep: 1482) Oct 5, '17 at 5:32 am
Add to Discussion

Answers

1

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?

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login