date boolean function
 

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.

date boolean function
 

Try

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

Mike

"Lisa" wrote:

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.

date boolean function
 

try

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


"Lisa" wrote:

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.

date boolean function
 

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.

date boolean function
 

Just for variety:

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

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Lisa" wrote in message
...
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.

date boolean function
 

It worked. Thank you.

"Lisa" wrote:

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.

date boolean function
 

One mo

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


Lisa wrote:

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.

--

Dave Peterson