Help

Date Fields dynamically fill based off one manually entered date field

265 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