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