Excel 2013

[ray388]

i have 1 page with header on it, plus boxes covering hole page.
i need to put the dates for one year down the left in the first row of boxes in weekly form, so how do i get, say 4 weeks onto 12-13 sheets covering the year. the header needs to be on all pages along with the boxes.
thank you.

[TTG]

I think what you are after is weekly dates? Create starting date in first cell a1. Then in next cell a2 create a formula that states =a1+7. Copy/paste formua into other rows.

[ray388]

no that's not what I'm after, don't think i explained it very well.
i know how to get all the dates, its just i want to put the first week in, and a space at the bottom to total things, then drag down filling the first page (say with 4 weeks).
i do that, but thought there must be a way to continue with the dates to run onto the other 12 sheets with the headers and boxes.
i know its an idiots guide i normally need.
thank you.

[Peter Pedant]

you tube has a zillion excel courses
I am very keen on "excel is fun"
here https://www.youtube.com/user/ExcelIsFun

[Peter Pedant]

and this -
which wont be what you want but possibly near
you should search within you tube for "excel date and time"

this does dates a bit

[Peter Pedant]

or this

http://www.excel-easy.com/functions/date-time-functions.html

it will be out there somewhere

[THECORBYLOON]

If you click on ctrl and then press each worksheet tab so they are grouped, anything you input in one sheet will appear in the others. It's important to mind and ungroup them when you're finished so just click on another tab. You could do a simple formula so the dates of the four weeks on each sheet are based on another date in the same sheet. That way, you need enter only the appropriate date on each set and the formulas will work out the dates.

Another way is to have the sheet the way you want it and then you can right click on the tab and you should get the option to create a copy of that sheet which will insert in that workbook. If you group the original and copy as above, you can copy both to create four in total and then repeat until you have twelve.

You will need to amen the formulas on each sheet so it has the right dates but the sheets will have the correct headers and formatting.

[ray388]

i have 1 page with header on it, plus boxes covering hole page.
i need to put the dates for one year down the left in the first row of boxes in weekly form, so how do i get, say 4 weeks onto 12-13 sheets covering the year. the header needs to be on all pages along with the boxes.
i know how to get all the dates, its just i want to put the first week in, and a space at the bottom to total things, then drag down, filling the first page (say with 4 weeks).
i do that, but thought there must be a way to continue with the dates to run onto the other 12 sheets with the headers and boxes.
i know its an idiots guide i normally need.
thank you.