View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.