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

Do you think the cable television business is going to change drastically in the next 5 years?

Discuss in The Lounge

Poll History