Compare month and year in excel 2003!

[Legacy 169354]

Hi,

I need to compare a month and year of a cell to assertain whether the cell should be a particular Date.

Excel 2003 is the product.

eg:

A B C
month ID Date
1 Jan 11 123 2 Jan 11
2 124 22 Jan 11
3 Feb 11 211 1 Feb 11
4 222 12 Feb 11

Logical Tests:

If A1 month and year is = C1 month and year THEN do nothing in A1
AND
If C3 month and year is <> C2 month and year THEN print in A3, the month and year of C3.

Thanks!

 

[Legacy 169354]

This seems to work at the moment!

=IF(AND(MONTH(C382)=MONTH(C381),YEAR(C382)=YEAR(C381)),TRUE,FALSE)