Many thanks for the help.
It worked for the first question.
For the second question , I have change the format.
Is it possible as well that I can copy the cell value (23/12/2014) to all fields in column B till it reaches TOM (A1) for example?
Something like below