Hi

Enter you date in a cell e.g. in cell A1
Right click the cell, FormatCellsNumberCustom ddd dd.mm.yy
In the cell beneath enter
=A1+1
Hover the mouse over the bottom right corner of cell A2, until it
changes to a small black cross (the fill handle)
Hold left mouse button down a you drag downward as far as required and
it will copy the formula, adjusting as it goes to A2+1, A3+1 etc. to
give your range of dates

--
Regards

Roger Govier


"RPD" wrote in message
...
Hi,
I want to auto insert custom dates as per this example: Fri 12 01 07

(I then hope it can auto fill a group of cells consecutively ie
Sat 13 01 07
Sun 14 01 07
Mon 15 01 07 etc for the week)

Can anyone please help me do this. I am most grateful (I have spent
time
looking at the help files, but cannot find an answer anywhere. Also I
am new
to Excel &
as I am just starting to use it do not fully know or understand it!).
Many thanks

--
RPD