| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have year based data want to convert into weekly basis
How can I collate daily based data to weekly data eg : 21st july 08 - 25th
july 08. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I have year based data want to convert into weekly basis
To make a start, create a new worksheet and put the first date
(starting date) in A1. This might be a Monday date. Then in A2 put this formula: =A1+7 and copy this down the sheet as far as you need. So, that has got the weekly periods set up. For the rest of it you will have to tell us something more about your data. Hope this helps. Pete On Jul 23, 10:50*am, Aadhya wrote: How can I collate daily based data to weekly data eg : 21st july 08 - 25th july 08. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generating a dynamic monthly summary sheet based on weekly data sh | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Summarize employee attendance data on a weekly basis | Excel Worksheet Functions | |||
| Finding number of values in a range on a per year basis | Excel Worksheet Functions | |||
| IRR weekly basis cashflow | Excel Worksheet Functions | |||
Hybrid Mode
