Consider your date lies in cell A1, then use the following formula to convert it into a date: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

As for your first question, what header are you talking about...?

- Mangesh