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
=IF(OR(C2=A2,C2=B2),"Equal","Not Equal") If C2 equals A2 or if C2 equals B2 then Equal, else Not Equal.
Bryan