Need help on comparison of dates in different format.

  • Thread starter Thread starter Chris
  • Start date Start date
C

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

Frank Kabel said:
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 ***
Click to expand...
Click to expand...
 
Back
Top