Date Formate

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

Custom Format

Please Login or Register  to view this content.

Then with the mouse go to the bottom righthand corner of the cell
Left click and hold and drag acoss or down for the required number of days and release