I have a column labeled as Production Start: This date is manual inputted.
I have a column that states estimated # of days that is auto generated using a formula;
I want to add the estimated # of days to the production start to give me a end date, excluding weekends, and holidays.
I used the following formula, but this is not correct.
NetWorkingDays() is for calculating the working days between two dates.
To add X business days to a date, use
(optionally you can add a third parameter for a list of holidays - I usually keep this list in a table in my doc, so I can reference it in multiple business-day-related formulas. If you do it like this, your third parameter would be
HolidaysTable.HolidayDate if you call the date column in the holidays table HolidayDate. For bonus points, I have a doc in my workspace that has a table of all the holidays observed by my organization, and then use Cross-Doc to pipe it into any docs that need business day math, so that I can update the holiday list in one place and have it automatically propagate everywhere else)