Skipping Weekend Dates for Editorial

Hi all, I’ve searched far and wide and can’t find a concrete formula/answer for this. The closest I got was using this formula “(WORKDAY({Launch Date}, -7)” but that doesn’t work. So you see my need is this:

  • When I add a set of topics to airtable I also assign a due date in a separate column. Currently, to do this I have a column set to “date”, add two consecutive dates, and then like excel I drag those two cells down continuously, which adds 1 day in the future.
  • However, weekends are currently included in this so I manually have to edit this which takes up time.

So my question: is there a formula that will allow me to assign a due date at different intervals (some writers only work 3 days a week) and skip weekends? For instance, if the start date is Jane 31, and the writer is set to complete 5 a week, the calendar would automatically skip Feb 1 and then assign Feb 2,3,4,5,6 and then skip Feb, 7, 8 and so on.

Much appreciate the advice or help.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.