| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Excel data in varying length financial periods 4/5 weeks
Need to summarised order/invoice data by financial period. This Financial
Year we have 12 Financial Periods each involving the following number of weeks: P1 = 4, P2 = 4, P3=5, P4=4, P5=4, P6=5, P7=4, P8=4, P9=5, P10=4, P11=4, P12=5. In MS Excel is there a way of Grouping Dates to reflect these varying lenght periods so we can use the Group in Pivot Tables? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting weeks to periods | Excel Discussion (Misc queries) | |||
| Web Query from multiple varying length pages | Excel Worksheet Functions | |||
| extracting data from a text string of varying length | Excel Discussion (Misc queries) | |||
| Group data by weeks not months | Excel Discussion (Misc queries) | |||
| Calendar 13 Periods 4 weeks each | Excel Discussion (Misc queries) | |||
Threaded Mode
