| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! -- SlipperyPete ------------------------------------------------------------------------ SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220 View this thread: http://www.excelforum.com/showthread...hreadid=534218 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I compare two dates?
=--(A1=B1)
copy down -- Regards, Peo Sjoblom http://nwexcelsolutions.com "SlipperyPete" wrote in message news:SlipperyPete.26iriy_1145463306.0187@excelforu m-nospam.com... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I compare two dates?
Try...
C1, copied down: =IF(A1<B1,1,0) Hope this helps! In article , SlipperyPete 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I compare two dates?
thanks! ended up using =--a1=b1 to generate TRUE/FALSE -- SlipperyPete ------------------------------------------------------------------------ SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220 View this thread: http://www.excelforum.com/showthread...hreadid=534218 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Compare date of a transaction against a range of dates | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| conditional formatting - compare 2 dates | Excel Discussion (Misc queries) | |||
| Compare range of dates and sum... | Excel Discussion (Misc queries) | |||
Linear Mode
