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

Hi,
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.
Thanks!

Hi @Jill_Engledow,

Welcome to the Community! Thanks for posting :slight_smile:

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!

1 Like

Thanks so very much!! That worked perfectly.
Jill

Happy to help, Jill :slightly_smiling_face:

Have a great day!

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.