Hi, Please help me in comparing dates in Excel.

Let the cells have dates as given below...

A2 = 10-Jan-2009

B2 = 20-Feb-2009

C2 = 30-Mar-2009.I need a formula that checks if C2 is equal to any of the dates given in A2 or B2.

I tried with this and got an error but could not get it right... :(

=IF(C2= A2 OR B2, "Equal", "Not Equal")

Try This: 1st - Highlight Column Data Cells

I.E. Cells A1 thru A100On the Menu Bar:

2nd - Format

3rd - Conditional Formatting

4th – Change “Cell Value is” to “Formula Is”

5th – Enter the formula:=COUNTIF($A$1:$A$100,A1)>1

Sub Menu Format :

6th - Patterns

7th - Choose a pretty color

8th - Press OK

9th - Press OKDuplicate records should now be highlighted in your selected pretty color.

Too go along rows up to the letter D use this:

1st - Highlight Column Data Cells

I.E. Cells A1 thru D1

change formula to:=COUNTIF($A$1:$D$1,A1)>1

MIKE

=IF(OR(C2=A2,C2=B2),"Equal","Not Equal") If C2 equals A2 or if C2 equals B2 then Equal, else Not Equal.

Bryan

Ask Your Question

Weekly Poll