Hi

For row 2
=DATE(2004,MATCH(A2,{"January","February","March", "April","May","June","July
","August","September","October","November","Decem ber"},0),SUBSTITUTE(SUBSTI
TUTE(SUBSTITUTE(SUBSTITUTE(B2,"st",""),"nd",""),"r d",""),"th",""))


Arvi Laanemets


"Ket" wrote in message
...
Hello,

I am using Windows XP with Office XP. I have two columns. Column A
contains months of the year in the format January, March December etc.
Column B contains dates in the format 11th, 16th, 20th etc.
Is it possible to combine these two cells to produce a date? Can a
sort then be undertaken on this new date column so that all
information is sorted chronologically?
I tried using concatenate to combine the cells but couldn't get them
to be recognised as dates.
Thanks in advance for all your assistance.

Ket
London