I am building a table of all elected offices in my county. I have the term of office, 2, 4, 6 years (so far no others) but I want to have a calculated field for the next year an office is up for election. So, today, I want the record for PRESIDENT so show the next election is 2020. On 1/1/2021, I want it to show 2024. Can anyone advise me on this one? Thanks
Calculate "year of next election" for elected office
+21Welcome to the community, Jan! :grinning_face_with_big_eyes: This should do the trick:
In the {Base} field, enter any previous year when an election for that office was held. The {Term (years)} field should be self-explanatory. The formula in {Next Election Year} is:
(ROUNDUP((YEAR(TODAY()) - Base) / {Term (years)}, 0) * {Term (years)}) + Base
Once this is set up, you can hide {Base}, as it’s not really needed beyond the setup stage.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.