WORKDAY Function

The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values. For example, these values would be operating days, holiday’s, etc. This is explained in the examples below. Syntax: =WORKDAY (start_date, days, [holidays]) start_date – The starting date days – Working days before or…