Need help on comparison of dates in different format.

[Chris]

Hi
I have question pertaining comparison of dates in different format :-
eg.

20 April , 2004 [Cell A1]

20-4-04 [Cell A2]

I was using if not function. ie. if(A1=A2, True, False). The result
always shown as False.

Pls help as to how could I do correct way solving this problem.


** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Frank Kabel]

Hi
are both cells real date values or are they stored as 'Text'?.
Check both values with
=ISNUMBER(A1)
=ISNUMBER(A2)
this should return TRUE for both cells

 

[Dave Hawley]

Hi Chris

You should enter both dates as VALID dates, see:
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

Then format as needed. When your dates are valid your IF function will
work as expected

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Niek Otten]

If one or both of the dates are the result of a computation or of the NOW()
function, they may contain a time fraction, although that doesn't show.
Try compare =INT(A1) and =INT(A2)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Hi
are both cells real date values or are they stored as 'Text'?.
Check both values with
=ISNUMBER(A1)
=ISNUMBER(A2)
this should return TRUE for both cells

--
Regards
Frank Kabel
Frankfurt, Germany

Hi
I have question pertaining comparison of dates in different format :-
eg.

20 April , 2004 [Cell A1]

20-4-04 [Cell A2]

I was using if not function. ie. if(A1=A2, True, False). The result
always shown as False.

Pls help as to how could I do correct way solving this problem.


** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***