Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
070403 formula for adding x periods/mo add 11% to each
hi, trying to find progress on a number: 100 starting apr 1, add 11% each 4 business days. trying to get a separate progress for each month. have figured business days as: (Jan-Dec) 22 20 22 21 23 22 23 22 21 22 21 22 days /mo: 21.75 days /yr: 261 reps /yr: 65.25 reps /mo: 5.4375 guessing start 1st col with months, next with start figure in apr: 100 column: monthly totals (times 5.4375 reps..) column: running total ----------- don't know if this is similar to old math trick start with add 1 penny on 1st day of month, double that every day for 30 days equals... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
365-day divided into 13 periods | Excel Discussion (Misc queries) | |||
Adding periods to sentences. | Excel Discussion (Misc queries) | |||
Whats the formula to look at data in precentages in fixed periods | New Users to Excel | |||
Dates and periods | Excel Worksheet Functions | |||
13 periods | Charts and Charting in Excel |