How to Auto-populate Dates based on +/- Number of ...

[Kyle_Groger]

Hi,

I’m using Airtable to manage my library. I was hoping I could use it to automatically calculate the due date based on the date I loaned the book out. For example, if I loaned the book on the 5th of October, I want to add 14 days and have a column saying 19 October for due date.

How do I do this?

Regards

[Nataliya_Bondar]

So, should it work implementing workdays? Is any solutions exist? Thanks!

[Nathalie_Collin]

This one will work for just workdays.

WORKDAY({Date},6)

[Nataliya_Bondar]

Thank you very much!!! You are the BEST!

[Beth_Gale]

has this been more simplified? I have many projects I would like to use this formula on but the holidays and weekends will always be different? unless I add every single weekend date which would be a forever list…?

[Cendecon_Crime_]

I'm hoping you can help me too. I'm trying to take someone's hire date from a date field in airtable and generate an anniversay date 1 year later.

[Faisal]

It does not work