| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I make different length months the same value?
If I am doing a monthly report with daily figures, some months will be worth
more based on the days. How do I give the twelve months a relative value so that February is worth the same as any other 31 day month? |
|
#2
|
|||
|
|||
|
this is statistsical llproblem. why not have one days rate. jan values will
be divided by 31 and february will be divided by 28(or 29). how about that. bee333 wrote in message ... If I am doing a monthly report with daily figures, some months will be worth more based on the days. How do I give the twelve months a relative value so that February is worth the same as any other 31 day month? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plotting different length series in a chart | Charts and Charting in Excel | |||
| make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Linear Mode
