|
|
#4
08-10-2011, 05:48 AM
|
|||
|
|||
Sorry Tony, but no matter how you format the same date in different cells, when you compare these cells with a formula will say they are equal, except the case when one of the cells is formatted as text...
if this is the case here, the problem can be solved converting text in date, with : =DATE(RIGHT(L16;4);MID(L16;4;2); LEFT(L16;2)), where L16 is the cell containing date formatted as text; only now you can correctly compare dates ... 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Calculating age at date
|
jamierbooth | Excel | 2 | 02-22-2011 03:35 AM |
|
Date Formatting in MS word 2007
|
Karthick | Word | 4 | 01-19-2010 05:54 AM |
|
Inserting Date, formatting to superscript and subscript
|
louq | Word | 1 | 10-22-2009 09:29 AM |
| new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
|
Imported message date change to today's date
|
promark | Outlook | 1 | 12-23-2005 07:21 AM |
Windows Vista 
Office 2007
Threaded Mode