Re: 2007 - Pulling date from a date range

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Jul 23, 10:51 am, "Rick Rothstein \(MVP - VB\)"
<rickNOSPAMn...@xxxxxxxxxxxxxxxxx> wrote:
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?

I think this does what you want...

=TODAY()+MIN((IF(D1:T1>=TODAY(),1,-9999))*(D1:T1-TODAY()))

NOTE: This is an array formula and must be entered using Ctrl+Shift+<Enter>.

Rick

Rick, Thanks for your help.

I insert the formula and come back with the date 11/13/3266

The dates I have from D1:T1 are as follows....

Starting with D1 5/32007, E1 5/6/2007, 5/10/2007, 5/17/2007,
5/20/2007, 5/31/2007, 6/7/2007,6/21/2007,6/24/2007, 7/8/2007,
7/12/2007, 7/15/2007, 7/19/2007, 7/22/2007, 8/2/2007, T1 8/5/2007.

Ideally, the cell with the formula, should pull the 8/2/2007 date for
right now.




.

Quantcast