Date Comparison

[Vic]

What is the formula for comparing dates?
I need to put digit "1" into AG if AF is greater than Z. AF may be blank. Z
always has a date.
Thank you.

 

[Mike H]

Vic,

2 ways

=--(AF2>Z2)

or

=IF(AF2>Z2,1,"")

The second formula leaves the cell blank if false

Mike