Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I need a basic formula that will take the employees start date and todays date to calculate years of service?
Create a column titled "Years of Service" and use this fomula (assuming your start date column is called "Start Date")
=YEAR(TODAY()) - YEAR([Start Date]1)
Thank you Sanjay. That was exactly what I was needing.
