Pls Help Me!!

[davidtips]

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 |
+-------------------------------------------------------------------+

 

[ScottO]

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

|
| 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?action=getinfo&userid=19103
| View this thread: http://www.excelforum.com/showthread.php?threadid=384251
|

 

[Bob Phillips]

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