Hi,
I want to know that how can I calculate the average tenure for year and month.
Example:- column A contains first name, Column B contains last name and Column C contains length of service.
Which formula I should try to get the average tenure.
Thanks
Nisha
Thanks
Nisha Dhawan
If you like my answer please click on * Add Reputation
"If you can dream it, You can do it"
What sort of data is there in the length of service column? I mean, is it months, or years or what?
Can you attach a sample workbook?
Cheers!
Deep Dave
I see nothing in there that can be used to calc a time period, you already have length of service, is that not tenure (duration)?
How would you calc this manually?
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
If you have the length of service in column C in numbers then use AVERAGE(Cxx:Cxx) to get the average length of service.
@ cbatrody, hmm perhaps you were the only 1 (so far) to read this question properly
"Please find the below formula to calculate the tenure of an Employee.
=datediff(B1,C1,""y"")&"" years,""&DATEDIF(B1,C1,"" ym"")&"" months""
Click on show video to view calcuation.
As you asked about Average tenure, so you can use avarage() formula to calculate average tenure."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks