2007 - Pulling date from a date range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi! -

I was hoping someone could help me please. Here's what I have. A
work*** that has several dates in a row. D1:T1, Of that range, I
have conditional formatting set to highlight a date(s) either = to or
within the next 7 days.

I need to be able to pull the date next closest or equal to today.
Can anyone help me out?

Any help would be greatly appriecated.

Shaun

.


Quantcast