Compare month and year in excel 2003!

L

Legacy 169354

Guest
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!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
L

Legacy 169354

Guest
This seems to work at the moment!

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

Watch MrExcel Video

Forum statistics

Threads
1,108,810
Messages
5,525,010
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top