Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help: How to use DATEADD with business hours and working days

Topic Labels: Formulas
499 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone!

I’m adding a date field {Fecha de inicio} and a duration field {Tiempo de impresión} to get an end date with hour. But I need to know if the result can skip/exclude non working hours and days so the results are not for example, Sunday at 4 am but Monday at 8am

This is what I have now:
DATEADD({Fecha de inicio},{Tiempo de impresión}, ‘seconds’)

I’d appreciate if someone can help! :slightly_smiling_face:

1 Reply 1

Hi @Tere_Hinojosa,

Welcome back!

You can do the day calculation with the Workday formula, shown below. Incorporating the time into it though would take a bit more. I imagine it would be an IF statement looking at the time, and if its too early, it would be the workday prior and if its too late, it would be the next work day.

WORKDAY(startDate, numDays, [holidays])

Let me know if you have any questions.

Chris