update week to week in excel.
 

New to excel. My weekly traffic report is updated weekly by me. I'm on week
36. next week when I update the report can the week automatically update to
week 37, the next week 38, etc. without manually typing it each week.
Also can the date change from 9/3/2006 to 9/10/2006 and advance 7 days each
time I do my report automatically.
In other words, I don't want to type in the week # or next week's date
manually.
Hope this makes sense. Probably pretty basic.
Thanks
Rudy

update week to week in excel.
 

Rudy,
I think the answer is most likely YES, that can be done, but we need to know
how you are doing your weekly traffic reports themselves?

Are they all on one sheet, or is a new sheet used each week in just one
workbook, or do you use a new workbook (.xls file) each week?

We probably need to know a little about the layout of a weekly traffic
report? It would make a difference if a report consisted of several rows of
information or if it just consisted of one row.


"Rudy" wrote:

New to excel. My weekly traffic report is updated weekly by me. I'm on week
36. next week when I update the report can the week automatically update to
week 37, the next week 38, etc. without manually typing it each week.
Also can the date change from 9/3/2006 to 9/10/2006 and advance 7 days each
time I do my report automatically.
In other words, I don't want to type in the week # or next week's date
manually.
Hope this makes sense. Probably pretty basic.
Thanks
Rudy

update week to week in excel.
 

=WEEKNUM(TODAY())

mama no teeth

"Rudy" wrote:

New to excel. My weekly traffic report is updated weekly by me. I'm on week
36. next week when I update the report can the week automatically update to
week 37, the next week 38, etc. without manually typing it each week.
Also can the date change from 9/3/2006 to 9/10/2006 and advance 7 days each
time I do my report automatically.
In other words, I don't want to type in the week # or next week's date
manually.
Hope this makes sense. Probably pretty basic.
Thanks
Rudy