Need help on Date plus 20 days

[Paulo_Calisto]

Hi, I need for CRM to create a formula where it is 20 days after the the last day I add a contact with that person. How to do that?
Thanks!

[Justin_Barrett]

Welcome to the community, @Paulo_Calisto! :grinning_face_with_big_eyes: The DATEADD() function will do what you want. Let’s say you have a date field named {Last Contact}. Your formula for something like a {Next Contact} field would be:

DATEADD({Last Contact}, 20, "days")

More details here:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

[Paulo_Calisto]

Thanks a lot @Justin_Barrett !