Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Calculate a due date based on number of days prior to arrival date

1130 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have an accommodation business, I am trying to calculate a due date for the final payment which is based on the number of days (generally 60) prior to their arrival date. I appreciate any assistance.

3 Replies 3
Airtable Employee
Airtable Employee

Hi @Jill_Engledow,

Welcome to the Community! Thanks for posting :slightly_smiling_face:

To calculate a due date based off an arrival date field, I would recommend using a formula field with the DATEADD() function.

For example, you could a formula similar to: DATEADD({Arrival Date}, -60, 'days') which subtracts 60 days from the date in the “Arrival Date” field. Please note, you may need to change this to match the field name in your table if you try this formula.

Screen Shot 2020-07-17 at 10.50.21 AM Screen Shot 2020-07-17 at 10.50.29 AM

Here is our Formula Field Reference for more information.

Hope this helps!

Thanks so very much!! That worked perfectly.

Happy to help, Jill :slightly_smiling_face:

Have a great day!