Convert the date to day of the week.
Nils - with the regional date settings you've described, and the
imported "date" in cell a2, in a cell formatted "general" the formula
below will return the NUMBER that represents the date for the ddmmyyyy
format you've described. Your example of 25022008 would appear as
39503 representing February 25, 2008.
=VALUE(CONCATENATE(MID(a2,3,2),"/",LEFT(a2,2),"/",RIGHT(a2,2)))
Then you can FORMAT it as a date.
Cliff Edwards
|