Skip to main content

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!

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?


I’ve been burned by that a few times so wanted to check with you. Here’s an example of it:

Reply


Terms & Conditions