Date Fields dynamically fill based off one manually entered date field

[vr]

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!

[TheTimeSavingCo]

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