Hello, I need to calculate average tenure for employees, but would like the months shows as .01 to .11 to represent 1 to 11 months in the file. My ADP HRIS system spits out the result, but doesn't show how it was calculated. Example attached. Any help is appreciated.
How do you count months? Sometimes you count the leftover days as an extra month, sometimes not.
10/10/2016 3/25/2020 3.05
this is 3 years, 5 months, and 15 days, and you ignore the extra days and call it 3 years 5 months
09/01/2017 3/25/2020 2.07
this is 2 years, 6 months, and 24 days, you count the extra days as another month
If you count only complete months, this formula is what you want, but it doesn't match your data.
Formula:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
thank you, this is really really helpful! I think the rounding up will be OK!
Actually my formula rounds down. If you need something different let me know. You can either round to the nearest month, or round up.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks