Formula to compare two columns with dates

[sprlvlyldy]

Hi All,

I know this should be really simple, but for whatever reason I can't seem to get it. I have two columns with dates. One column is Occurence Date (column C) and the other is Alert Date (column D). I need to show if the dates in column C are equal to or less than the dates in column D.


Thank you in advance! =)

 

[OleMiss2010]

Two options:

1. You can use a helper column (Column E in this case) and put the following formula in:

=IF(C1>D1,"",C1)


2. You can use conditional formatting with the same formula.

 

[sprlvlyldy]

This shows the ones that are greater/less than, but is there a way to also put in the formula to show it as true if they are also equal dates?

 

[OleMiss2010]

This formula shows column C if it is not greater than column D (i.e. if it is less than or equal to).

 

[sprlvlyldy]

ooooooooooh I get it now. Thank you!