As I know there are a few excel masters on here…

I have a column titled ‘week ending’ with the dates below in the format 09-Oct-11
16-Oct-11
etc.

To save me typing the new date each week can I get excel to do it for me?

In an ideal world i’d keep the format how it is but if it needs changing i.e. 09-10-11 then I might be able to live with that.

Thanks in advance. 🙂

=A1+7

(assuming A1 is where the date is so replace A1 with whatever cell your date is in)

Put the first two dates in, then highlight them both and pull the fill handle across to auto populate the other cells.

*or down, in this case.

sweeeeeeet
thanks guys

🙂