Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Date Fields dynamically fill based off one manually entered date field

662 1
cancel
Showing results for 
Search instead for 
Did you mean: 
vr
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

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