Formula to find the earliest date that maches a name, but when the column has 1 as a date?

[tonywatsonhelp]

Ok I'll try explain this,

I need a fformula that can return the start date of a promotion we are doing by look for the promotion name and finding the first date

now here's my big problem,

some times part of the promotion has no date, so the formula that calculates the start date returns "01/01/00" or if I change it to general it says just "1"

so when I use =MINIFS(Projects!C:C,Projects!D:D,CZ2) I get that value.

so how can I get the first date ignoring the error date of 1?

Heres how everything is set up,

Column C is the dates
Column D is the promo names

CZ2 is the cell with the Promotion I want to look up in

please help

thanks

Tony

 

[Eric W]

Try:

=MINIFS(Projects!C:C,Projects!D:D,CZ2,Projects!C:C,">1")

 

[tonywatsonhelp]

Briliant Eric,
thanks

Tony