Data Text to Columns Next Next select Date: DMY Finish

Custom Format
ddd, d mmmm yyyy


"86" wrote:

Is it possible to have a function where if you enter the date numerically, eg
'30/3/7'
it returns the DAY & date, eg 'Fri, 30th March 2007' ?

This would obviously work off the computer calander so as to ensure it gets
the day of the week correct.

Thanks