Vic,

2 ways

=--(AF2Z2)

or

=IF(AF2Z2,1,"")

The second formula leaves the cell blank if false

Mike

"Vic" wrote:

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.