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