Welcome to the community, @Diane_Madonna_Beckle! :grinning_face_with_big_eyes: This can be done by adding a formula field that uses the DATEADD()
function. This function takes three arguments (arguments are input values for a function):
- The starting date. This will come from the field where you’re tracking your last inspection date. I’ll use
{Last Inspection Date}
for now; replace it in the formula with your actual field name.
- An interval value. In your case, that’s 365.
- An interval type. In your case, you’ll use “days”.
The final formula looks like this:
DATEADD({Last Inspection Date}, 365, "days")
I recommend bookmarking Airtable’s formula field reference page, where you can learn about other available functions. As a side note, I’m working on a course all about Airtable formulas. It’s been delayed for various reasons, but I’ll be sure to post to the community once it’s done.
Welcome to the community, @Diane_Madonna_Beckle! :grinning_face_with_big_eyes: This can be done by adding a formula field that uses the DATEADD()
function. This function takes three arguments (arguments are input values for a function):
- The starting date. This will come from the field where you’re tracking your last inspection date. I’ll use
{Last Inspection Date}
for now; replace it in the formula with your actual field name.
- An interval value. In your case, that’s 365.
- An interval type. In your case, you’ll use “days”.
The final formula looks like this:
DATEADD({Last Inspection Date}, 365, "days")
I recommend bookmarking Airtable’s formula field reference page, where you can learn about other available functions. As a side note, I’m working on a course all about Airtable formulas. It’s been delayed for various reasons, but I’ll be sure to post to the community once it’s done.
Thank you so much! I was so close with the formula. I missed adding one comma……throw the enter formula off. I can’t thank you enough!

I have one more question, how do I get the date without the time?
I have one more question, how do I get the date without the time?
Check the field’s format options to remove the time.