How to calculate Completed Years for Employee

Hi,

I am wondering how to go about calculating the number of years completed at a company by an employee based on their start date. I can see ways doing this but doesn't seem very PLANS, can someone please advice on it or link to micro lesson for example?

Best regards,

Johan

Comments

JussiLi

Hi @johan.marketoft,

I would use YEARFRAC function for that. And put it inside ROUND function to get the number of full years.

I case you want to compare employee start date to current date that might be trickier because Anaplan doesn't have a function to give you current date (like NOW() function in Excel).

You need to import current date from outside Anaplan.

Best regards,

JussiLi

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…