Hi there

Is there a custom formats that allows me to do the following In excel

Monday 01/9/15 then when it is copped across I then auto populates with Tuesday, etc