Formula to determine fiscal year relative to date in other clumn


#1

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!

Thanks!


#2

You have IS_AFTER/IS_BEFORE functions: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#date_and_time_functions


#3

Check here all the Date Formulas you can work with.