date boolean function

L

Lisa

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.
 
S

Stefi

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

Regards,
Stefi

„Lisa†ezt írta:
 
S

Sandy Mann

Just for variety:

=A1-DAY(A1)=B1-DAY(B1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
D

Dave Peterson

One more:

=text(a1,"yyyymm")=text(b1,"yyyymm")

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.
Click to expand...
 
Top