how do I compare two dates?

OK -- I have two lists of dates, and I want to compare them & generate a result of '1' if they are different, a result of '0' if they are the same.

For example:

column A: -__-- column B:
01/01/2005 --- 01/01/2005
02/02/2005 --- 07/07/2001
03/03/2005 --- 08/31/1976

I'd like a formula that will compare these dates and generate the following:

column C:
0
1
1

Thanks!

=--(A1=B1)

copy down


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"SlipperyPete" <[email protected]>
wrote in message
news:[email protected]...
>
> OK -- I have two lists of dates, and I want to compare them & generate a
> result of '1' if they are different, a result of '0' if they are the
> same.
>
> For example:
>
> column A: column B:
> 01/01/2005 01/01/2005
> 02/02/2005 07/07/2001
> 03/03/2005 08/31/1976
>
> I'd like a formula that will compare these dates and generate the
> following:
>
> column C:
> 0
> 1
> 1
>
> Thanks!
>
>
> --
> SlipperyPete
> ------------------------------------------------------------------------
> SlipperyPete's Profile:
> http://www.excelforum.com/member.php...o&userid=31220
> View this thread: http://www.excelforum.com/showthread...hreadid=534218
>

Try...

C1, copied down:

=IF(A1<>B1,1,0)

Hope this helps!

In article <[email protected]>,
SlipperyPete
<[email protected]> wrote:

> OK -- I have two lists of dates, and I want to compare them & generate a
> result of '1' if they are different, a result of '0' if they are the
> same.
>
> For example:
>
> column A: column B:
> 01/01/2005 01/01/2005
> 02/02/2005 07/07/2001
> 03/03/2005 08/31/1976
>
> I'd like a formula that will compare these dates and generate the
> following:
>
> column C:
> 0
> 1
> 1
>
> Thanks!

thanks!

ended up using

=--a1=b1

to generate TRUE/FALSE