tag:blogger.com,1999:blog-68368394969303158.post4763004146985687747..comments2023-09-19T00:51:50.517-07:00Comments on MS Office Tips: Calculate Length of Service in ExcelAnonymoushttp://www.blogger.com/profile/17928183855719776190noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-68368394969303158.post-43469761552173297182021-11-26T18:34:16.295-08:002021-11-26T18:34:16.295-08:00I was just browsing for related blog posts for my ...I was just browsing for related blog posts for my project research and I happened to discover yours. Check out my blog if you want to <a href="https://getgoodstaff.com/" rel="nofollow">hire virtual assistant</a>boss2021sbloghttps://www.blogger.com/profile/06738353275859328891noreply@blogger.comtag:blogger.com,1999:blog-68368394969303158.post-92187015527166528032020-08-22T08:27:12.275-07:002020-08-22T08:27:12.275-07:00Cell b7 holds the start of service date
Cell b5 ho...Cell b7 holds the start of service date<br />Cell b5 holds the end of service date<br /><br />If you want to include both the start date and the end date (to show the actual number of days of service, including first and last day of service):<br /><br />=DATEDIF(B7-1,B5,"y")&" years, "&DATEDIF(B7-1,B5,"ym")&" months, "&DATEDIF(B7-1,B5,"md")&" days"<br /><br />If you do not want to include the start date (or the end date):<br /><br />=DATEDIF(B7,B5,"y")&" years, "&DATEDIF(B7,B5,"ym")&" months, "&DATEDIF(B7,B5,"md")&" days"bop.smithhttps://www.blogger.com/profile/11783710151366880382noreply@blogger.comtag:blogger.com,1999:blog-68368394969303158.post-66181273003650516012018-12-28T09:26:31.117-08:002018-12-28T09:26:31.117-08:00I have the same question! All I'm finding is &...I have the same question! All I'm finding is "today" and "months" formulas. Just need formula to calculate YOS from hire date only... 01/11/1988 to the year 2019. No "start date" and "end date".YWhttps://www.blogger.com/profile/07255351794632045053noreply@blogger.comtag:blogger.com,1999:blog-68368394969303158.post-82672829476740078612018-08-06T10:56:50.395-07:002018-08-06T10:56:50.395-07:00i need to do from the hire date hrough this year, ...i need to do from the hire date hrough this year, not todays date. what is that formula?Anonymoushttps://www.blogger.com/profile/05979419968419743980noreply@blogger.comtag:blogger.com,1999:blog-68368394969303158.post-16428209548399664332018-01-11T08:34:01.429-08:002018-01-11T08:34:01.429-08:00My formula is :
=DATEDIF(O2,AL$1,"y")&a...My formula is :<br /><br />=DATEDIF(O2,AL$1,"y")&" years, "&DATEDIF(O2,AL$1,"ym")&" months, "&O2-DATE(YEAR(O2),MONTH(O2),1)&" days"<br /><br />Where O2 is the hire date and AL$1 is today()<br /><br />The formula works, kinda. It isn't doing the math correctly. I have a person who started exactly a year ago and it is 2 weeks short...Anonymoushttps://www.blogger.com/profile/02830588418183590353noreply@blogger.comtag:blogger.com,1999:blog-68368394969303158.post-3253272436167459602016-08-24T00:57:00.464-07:002016-08-24T00:57:00.464-07:00sie calulate length of service in excel download k...sie calulate length of service in excel download kese hogeHanifhttps://www.blogger.com/profile/08002044677251018525noreply@blogger.comtag:blogger.com,1999:blog-68368394969303158.post-45037271745522206802016-08-24T00:52:46.820-07:002016-08-24T00:52:46.820-07:00sie calulate length of service in excel download k...sie calulate length of service in excel download kese hogeHanifhttps://www.blogger.com/profile/08002044677251018525noreply@blogger.com