MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
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. 🙂
Posted : 06/10/2011 10:26 am
=A1+7
(assuming A1 is where the date is so replace A1 with whatever cell your date is in)
Posted : 06/10/2011 10:27 am
Put the first two dates in, then highlight them both and pull the fill handle across to auto populate the other cells.
Posted : 06/10/2011 10:31 am
*or down, in this case.
Posted : 06/10/2011 10:32 am
Topic starter
sweeeeeeet
thanks guys
🙂
Posted : 06/10/2011 10:37 am