Hi all,
Please see the image below.
What I need to do is have the bottom right date as 14/07/2012, the one above it as 21/07/2012, etc, so going up in weeks. Then when I get to the top I need to go back to the bottom again but in the next column, then start going up in weeks again.
I can't seem to get auto-fill to do this in weeks like I want, especially as I am wanting it to go upwards, it just minus' one day of the date I start at.
I think it is possible as someone done this one for me, but now I need to update the dates and can't work out how
Does anyone know how? If not I will have to do it manually
Hope you can help
Please see the image below.
What I need to do is have the bottom right date as 14/07/2012, the one above it as 21/07/2012, etc, so going up in weeks. Then when I get to the top I need to go back to the bottom again but in the next column, then start going up in weeks again.
I can't seem to get auto-fill to do this in weeks like I want, especially as I am wanting it to go upwards, it just minus' one day of the date I start at.
I think it is possible as someone done this one for me, but now I need to update the dates and can't work out how
Does anyone know how? If not I will have to do it manually
Hope you can help