I’m building an HR Employee Details board and want to calculate an employees length of service. I’ve created Start Date and End Date columns, then a formula column called Length of Employment.
I’ve used the AI feature to write a formula and so far have managed to get the formula to:
Return the value in years, months and days, rather than just days.
Stop putting millions (slight exaggeration!) of decimal places on the days by rounding these.
But I’ve not been able to get the days to calculate properly. The formula doesn’t seem to account for a calendar year or leap years so is over calculating. Can someone help fix this formula please?
You could do it more easily with a 3rd-party app called the Advanced Formula Booster which not only does not use the formula column but allows you to create formulas using multiple lines.