Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Aggregating months over periods
Hello,
I have a number of unequal periods in a year. For this example say 5 periods. There are no actual dates here, just a raw number of months (number format) P1: 1 P2: 2 P3: 3.4 P4: 2 P5: 3.6 The numbers will always add up to 12. I am searching for a formula that will tell me how many periods make up a given number of months, moving backwards from a given period. Example 1 Cell A1 = # Months = 5 Cell A2 = Period Beginning = 4 Cell A3 = Formula = 1.882* * P4 = 1 using up 2 months P3 = .882 using up the remaining 3 months Example 2 Cell A1 = # Months = 5.8 Cell A2 = Period Beginning = 3 Cell A3 = Formula = 2.4* * P3 = 1 using up 3.4 months P2 = 1 using up 2 months P1 = .4 using up the remaining .4 months Any help would be very much appreciated. I have considered building an intermediate table to help the formula, but any advice would be great. Thanks, Ari Blum |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of months between 2 periods? | Excel Discussion (Misc queries) |