Calculate "year of next election" for elected office

Topic Labels: Formulas
1010 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2

Welcome 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.

4 - Data Explorer
4 - Data Explorer

Perfect. Thanks:grinning: