Match date 1 with min date 2 and return 1,0

[ante_]

Hi,

Cant get this to work, trying to match 2 dates/years where the second date/year is a MIN value from a series of 12 dates.

What im using:

G2=MIN(H2:S2) Dont want this to return anything if row is blank.

D2=IF(C2="";"";MIN(MONTH(C2)))

F2=IF(G2="";"";MIN(MONTH(G2)))

E2=IF(OR(C2="";G2="";"";AND(MONTH(C2)=MONTH(G2);YEAR(C2)=YEAR(G2)));"1";0)

Is it possible to do this in less steps?

[Kaper]

in E2 shall be enough:

Please Login or Register  to view this content.

missing C2 or nothing in H2:S2 -> blank cell
m(c2)=m(mindate) and y(c2)=y(mindate) -> 1
m(c2)<>m(mindate) or y(c2)<>y(mindate) ->0

[ante_]

Perfect! Thank you!

Best!