Date formatting

		Microsoft Office Forums > Microsoft Excel > Excel
Date formatting

FAQ

Thread Tools

Display Modes

08-10-2011, 05:48 AM

Catalin.B

Windows Vista Date formatting

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:23 PM.