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
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.