I am working on a vacation calendar project.
I have a custom lists with 2 columns, one being StartDate and the other NumberOfDaysTaken.
I am using a simple SharePoint formula (=FromDate + [How many Days]) to add the number of days to the start date to populate an EndDate column.
However this formula does not cater for weekends. For example if the start date is Thursday and the number of days is 6, the formula adds 6 days from Thursdays and enters Tuesday as the end date.
How can I exclude weekends from this calculation?