ExcelBanter - Date Comparison

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date Comparison (https://www.excelbanter.com/excel-discussion-misc-queries/246238-date-comparison.html)

Vic

Date Comparison

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

Date Comparison

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.

All times are GMT +1. The time now is 09:10 AM.