date boolean function

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

 

[Mike H]

Try

=AND(MONTH(A1)=MONTH(B1),YEAR(A1)=YEAR(B1))

Mike

 

[Duke Carey]

try

=and(month(a1)=month(b1),year(a1)=year(b1))

 

[Stefi]

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

Regards,
Stefi

„Lisa†ezt írta:

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Lisa]

It worked. Thank you.

 

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