Help

Workday Formulas - How do they calculate weekends?

Topic Labels: Formulas
839 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ToriAnn_Perkey
4 - Data Explorer
4 - Data Explorer

I’m new to Airtable and just getting a handle on formulas. I’ve done quite a bit of searching, but I can’t find a current answer to this.

I’m trying to set up a simple tentative timeline of due dates. The project is done multiple times and there are a standard number of days between each step.

I’ve created a simple table where the start of the project is entered manually and then each additional step uses this formula to calculate the next date:

For example: WORKDAY({Forms Sent}, 2)

With the {Forms Sent} being the previous step and the number being the number of days the current step takes.

However, I can’t figure out if the workday starts on Sunday or Monday. (Based on testing, it seems to start on Sunday.) Our workday is M-F, so if it is set to start on Sunday, is there a way to adjust it?

Thanks!

1 Reply 1

Hi ToriAnn, I don’t think there’s a way for you to adjust that I’m afraid

Do you think you might be being affected by the date field’s timezone checkbox? Specifically, this thing?
Screenshot 2022-08-22 at 2.37.31 PM

I’ve been burned by that a few times so wanted to check with you. Here’s an example of it:
Screenshot 2022-08-22 at 2.37.05 PM