Hi there!

Thank you in advance, as I really enjoy this site that solved most of
my problems.


01 File attached.
How can I have only 2 answers at *column C* (answer: 1 or 0) base on my
date input at *column A and B*?

If DATE B is earlier than DATE A = 1
If DATE B is same as DATE A = 1

If DATE B is later than DATE A = 0
IF DATE B is empty, = 0

Thanks again for solving my problem!
davidiew


+-------------------------------------------------------------------+
|Filename: Date123xx.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3562 |
+-------------------------------------------------------------------+

--
davidtips
------------------------------------------------------------------------
davidtips's Profile: http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=384251