I'm trying to figure out if there's a way to update a number field annually based on date. I've got a Position Start Date field, a Year of Experience On Entry field which is a number field that reflects the year(s) of experience the person had as of their position start date, and I want to create a field that adds +1 to the number in the Year of Experience On Entry field annually on their Position Start Date, and that field will be called to Current Year of Experience. Is there a way to write a formula that will calculate the Current Year of Experience?
POSITION START DATE | YEAR OF EXPERIENCE ON ENTRY | CURRENT YEAR OF EXPERIENCE |
1/15/2022 | 0 | 1 |
6/12/23 | 0 | 0 |
4/13/2018 | 1 | 6 |
Thank you for any thoughts you might have on this!