Did you see the example in the attached worksheet?

I put the formula in column E, then in column F i have added zero to make the date. you can then copy this column and paste special > values and formats back in column A and delete the formulas

re point 5 - this is how i would do it, but if i have learnt anything about Excel its that there will be 5 or 6 ways to to it