Formula for a date + 2 workdays at a defined time

Platform discussions Special workflows & use cases
,
1

I need to set a date to 2 workdays in the future at 10:30am so that I can trigger an automation at a specific time of day.

I have used the following formula =workday(today(),2) to get 2 days in the future, however the time returned is the current time. I would like to set a specific time. Does anyone know how to do this?

2

@gpbutler

If all you need is the syntax for a formula column, something like this will return that value you want:

FORMAT_DATE(WORKDAY(TODAY(),2),"YYYY-MM-DD") & " 10:30AM"

Jim - The Monday Man channel
Signup for a FREE Integromat account with this link and get a FREE hour with The Monday Man