Use Microsoft® Excel Differently to Gain a Productive Edge
Issue - Feb 2009
In the course of managing data with Excel, you are likely to encounter the need of calculating the number of years and months between 2 dates, such as the age of the employees, length of service, and of an investment, etc.
The most commonly used and straight-forward approach is to take the difference between the 2 dates to return you the numbers of days. The year is then calculated by dividing this number of days by 365.25 days (taking into account leap year occurrence). If the number of months cannot make up a complete year, then computation becomes much more complex.
Life can become simpler with some great Excel tips.
Make use of the MOD formula to determine the number of days left over after counting the number of full years and then divide it by 30.5 days (average number of days per month) . This gives a fairly good estimate of the months in the partial year if you can afford to ignore the difference in the number of days in each month.
If accuracy is very important, such as in the computation of employees' pay or bonuses, then you might be led to think that using macro is the only way out... more about Excel Age Calculator
If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.
If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and
"Excel Secrets for Highly Effective Marketers"
Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.