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.
