Comparing 2 dates (in different format)

[sdsurzh]

Hi,


How do I will compare 2 different format dates?


A1 = 13/02/2012 (DD/MM/YYY/)

B2 = 20100213 (YYYYMMDD)

C2 = TRUE ( I need formula)


Thanks in advance,

Suresh Kumar S

 

[NARAYANK991]

Hi Suresh ,


Convert the date which is in dd/mm/yyyy format to the other format , using :


=VALUE(TEXT(A1,"yyyymmdd"))


Now the above value can be compared to B2.


Narayan

 

[sdsurzh]

Thank You very much Narayan.