Oct 03, 2016 03:47 AM
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
Jun 04, 2019 03:27 AM
So, should it work implementing workdays? Is any solutions exist? Thanks!
Jun 04, 2019 03:29 AM
This one will work for just workdays.
WORKDAY({Date},6)
Jun 04, 2019 03:45 AM
Thank you very much!!! You are the BEST!
Sep 03, 2019 02:56 AM
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…?
Jan 30, 2023 11:59 AM
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.
Feb 16, 2024 12:06 AM
It does not work