Forum Discussion
Jason McIntosh
Jan 25, 2018Copper Contributor
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
- Haytham AmairahSilver Contributor
Jason,
You can use DATEDIF function, which is the best function for this purpose.
=DATEDIF(A2,B2,"y")