This function usually calculates the ship dates in Excel. In the above example we add 1 working day to the start_date 02-Jun-20 using the following formula. If you want to define the weekend or customize the non working days in a week then use the extended version of WORKDAY function which is WORKDAYINTL function.
A date that represents the start date.
The function uses the following arguments. The WORKDAY function in excel takes the start date number of days and the list of non working days. Days required function The number of workdays to be added to start_date. Use the formula WORKDAY A4B4A7 A7.