Pls Help Me!!
 

:confused: 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

Try this ...
=IF(AND(NOT(ISBLANK(B1)),B1<=A1),1,0)
Rgds,
ScottO

"davidtips" wrote in message
...
|
| :confused: 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
|

=--(AND(B1<"",B1<A1))

--
HTH

Bob Phillips

"davidtips" wrote
in message ...

:confused: 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