MIN IF

D

Daniel Bonallack

I have dates in column A that range between 2002 to 2006.

Can someone please provide me with the formula that gives me the minimum
date but only out of the dates that are greater or equal to Jan 1, 2006?

Thanks in advance
Daniel
 
A

Ashish Mathur

Hi,

Try the following array formula (Ctrl+Shift+Enter)

=min(if((range>1/12006),range))

Regards,

Ashish
 
B

Biff

Hi!

Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MIN(IF(A1:A100>=--"1/1/2006",A1:A100))

Or:

=MIN(IF(A1:A100>=DATE(2006,1,1),A1:A100))

Better to use a cell to hold the criteria:

B1 = 1/1/2006

=MIN(IF(A1:A100>=B1,A1:A100))

Biff
 
Top