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

Hi,

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

=min(if((range1/12006),range))

Regards,

Ashish

"Daniel Bonallack" wrote:

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

Perfect, thanks!

"Ashish Mathur" wrote:

Hi,

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

=min(if((range1/12006),range))

Regards,

Ashish

"Daniel Bonallack" wrote:

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

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

"Daniel Bonallack" wrote in
message ...
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