Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update week to week in excel.
Oops - got posted twice. I responded to your other posting.
"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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update week to week in excel.
Please re-answer. I didn't a response.
Thanks "JLatham" wrote: Oops - got posted twice. I responded to your other posting. "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update week to week in excel.
Sorry I didn't realize you answered with additional questions.
My report is all on one sheet. I use the same sheet each week. I enter numbers for each day on Sunday night. I have formulas in place for traffic count updates. I save this information and then next week when I open the report the week number is the same. so I usually type in the next week . This week 38 next week 39 and so on. cell b3 has the week number. Is there a function to update this number only from week 1, to week 2, to week 3. each week. I saved last nights work for week 36. Next week when I do my report I would like the report to reflect week 37 without manually typing 37 in that particular cell. "JLatham" wrote: Oops - got posted twice. I responded to your other posting. "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I Update Excel 97 to Excel 2002? | Excel Discussion (Misc queries) | |||
Last week for regular registration - London Excel User Conference - July 19-21 | Excel Worksheet Functions | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
Why does my Excel workbook take so long to update links? | Excel Discussion (Misc queries) |