Due Date Formula

Try this formula

Note - Agreed Date being the name of your column with the date

to add a number of working days to a date
FORMAT_DATE(WORKDAY({AGREED DATE},7))

Screen Shot 2019-12-16 at 01.03.50

to minus a number of working days to a date
FORMAT_DATE(WORKDAY({AGREED DATE},7-1))

Screen Shot 2019-12-16 at 01.06.34

Hope this helps

6 Likes