Help

Re: How do I add a set number of days to a date?

1142 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kyle_Groger
4 - Data Explorer
4 - Data Explorer

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

35 Replies 35

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

This one will work for just workdays.

WORKDAY({Date},6)

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

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…?

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.

It does not work

Screenshot 2024-02-16 at 09.05.38.png