Try this:
=AND(YEAR(A1)<YEAR(B1),MONTH(A1)<MONTH(B1))

Regards,
Stefi

€žLisa€� ezt Ã*rta:

If A1 has a date of 8-1-08 and B1 has a date of 8-1-09, I am trying to get a
True or False answer in C1 if the month and year of A1 and B1 do not match.
I have tried =A1(month&year)=B1(month&year), but it is not working. I am not
an excel pro and know it can be done, but I do not know where I my function
is wrong.