- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 30, 2024 10:57 PM
Hello!
Use Case: New Employees start at our company and we input a load of default events/meetings into their calendars
I manually input Start Date
and I want an automation/formula to input
Day 1 Start Start Date (ADD TIME 9am)
Day 1 End Start Date(ADD TIME 5pm)
Day 2 Start Start Date + 1 (ADD TIME 9am)
Day 2 End Start Date +1 (ADD TIME 5pm)
Making sure that Day is ALWAYS a weekday.
Hope that makes sense, thanks!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 01, 2024 02:50 AM
You can do this with formula fields with a combination of WORKDAY() to get the specific date, followed by a DATEADD() to get the specific time (i.e. 9am, 5pm)
https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference
