Date Comparison

V

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.
 
M

Mike H

Vic,

2 ways

=--(AF2>Z2)

or

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

The second formula leaves the cell blank if false

Mike
 
Top