Formula to determine fiscal year relative to date in other clumn


Hi there - I’m looking to set up a formula to determine fiscal year and can’t figure it out. Help appreciated

I tried setting up an IF function (i.e., if the date in the “Engagement End Date” column is on or after 7/1/2018, then the fiscal year is 2019, and if the date in the “Engagement End Date” is on or after 7/1/2019, then fiscal year is 2020.)

Also - is there a formula in Airtable comparable to IFERROR? I don’t quite think ERROR and ISERROR formulas are what I’m looking for. Thanks!



You have IS_AFTER/IS_BEFORE functions:


Check here all the Date Formulas you can work with.