Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
12ths denominators for fractions in Excel (for pension calcs)
As a pensions administrator, I use Excel to display pensionable service in
years and complete months. The ability to express service in terms of years and twelfths of a year would be useful. This is not one of the options for fraction formatting. In addition, pension calculations often require a period of service to becalculated between two dates (joining and leaving). This is often expressed in terms of years and months, where the months are not always complete calendar months, but a period of 28 to 31 days straddling a month end. eg 15 Jul 2000 to 14 Aug 2006 inclusive would be 6 years and 1 month. As a refinement, 31 Dec 2000 to 28 Feb 2006 would be 5 years and 2 months. Could a function be devised to calculate the number of complete years and months? Variations would be years and weeks, and years and days, possibly years/months/days and years/weeks/days. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
excel viewer | Setting up and Configuration of Excel | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel |