Generally, you spend about 5 hours weekly trying to find a file you need. 18 minutes more you try to discover it inside your management system. DocHub allows you to save precious time and get every file you need within your reach. Access Excel Staff Hiring Service Proposal Template Templates in one click and concentrate on activities that matter the most for you.
DocHub transforms usual file management and alleviates tedious file search procedures. Get all functions and features of document flow at your fingertips, no additional management platform is needed. Start your free DocHub trial right now.
in this video im going to show you the formula in excel on how to calculate years of service this is how to calculate the number of years from a historical date in excel were going to come up here were going to type this formula were going to say equals days 360. open parentheses were going to select the cell that has the higher date in there comma today then were going to say in open and close parentheses close the parentheses divided by 360. we hit enter and this formula will give us the years of service so all we have to do now is right click format the cell to a number and im going to say out to one decimal place and click ok then all i have to do is drag my formula down and my formatting if you found this video helpful be sure and give it a thumbs up be sure and check out my website sharonsmithhr.com dont forget to subscribe to my channel thanks for watching bye