Numbers help with formula running down a page
I havent fully searched the forum for this as wasnt entirely sure how to explain it, but i will try!
I am creating a spreadsheet to track who has completed a task most recently and down the left most collumn i want to have a date, (for example 02nd Jan 2011), which then increases by exactly one week each line you drop down.
So for example, A1 would show 02/01/2011 and B1 would show 09/01/2011.
How do i write the formula for this, and can I then fill down the page so that it follows this sequence for the entire year?
I hope i have provided a detailed enough explanation!
Thanks in advance for your help...