About Us

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

=--(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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Comparison	Christopher Naveen[_2_]	Excel Worksheet Functions	1	August 13th 09 06:01 AM
Date comparison	TomD	Excel Discussion (Misc queries)	4	February 20th 07 10:37 PM
date comparison help	CathyZ	Excel Discussion (Misc queries)	5	May 4th 06 11:53 AM
Date comparison	Darkdrew	Excel Worksheet Functions	7	March 23rd 06 04:22 PM
Date comparison	Jonibenj	Excel Discussion (Misc queries)	6	October 23rd 05 08:34 PM

Menu

About Us