I am creating a spreadsheet and want it to work so that I put monday's date
in, and the rest of the week's dates populate automatically. I have done this
before, so I know how to do it - but I changed the function (by mistake) and
can't remember which function I need to input this formula...

I have tried different functions, but the formula appears in the cell,
instead of the date (e.g. I enter 11/04/2005 in A1, then put formula in A2
[=A1+1] - but this formula is in the cell, not "12/04/2005", like I
wanted....)

Any help appriciated.

Thank you,

Rob,
Teesside,
UK