Forum Discussion
YEARS OF SERVICE
TRYING TO FIGURE OUT HOW TO CONVERT A SPECIFIC DATE INTO YEARS OF SERVICE.
EXAMPLE.... START DATE 09/051982 NEED YEARS OF SERVICE OS OF 2/01/2018
1 Reply
Jason,
You can use https://support.office.com/en-us/article/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c, which is the best function for this purpose.
=DATEDIF(A2,B2,"y")
