Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculate "year of next election" for elected office

Topic Labels: Formulas
532 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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:

30%20PM

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.

Perfect. Thanks:grinning: