Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
4-4-5 Calendar
I typed out my question just a second ago, but I don't think it posted
properly. If I'm repeating myself, I apologize! Anyway, I'm reviewing annualized financial data that are broken down into weeks. (I have this information in pivot tables.) I'd like to compare the information year over year by grouping it in a 4-4-5 calendar format. Is that possible? If so, are pivot tables the best option? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
4-4-5 Calendar
Pivot tables do not support a 4 4 5 natively. To use them for that you need
to attach your week number and year number to each record. That being said no matter what you want to do you are going to need to attach your week number and year to each record so a pivot table is as good an option as any. -- HTH... Jim Thomlinson "Liz J" wrote: I typed out my question just a second ago, but I don't think it posted properly. If I'm repeating myself, I apologize! Anyway, I'm reviewing annualized financial data that are broken down into weeks. (I have this information in pivot tables.) I'd like to compare the information year over year by grouping it in a 4-4-5 calendar format. Is that possible? If so, are pivot tables the best option? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |