WORKDAY Function

Originally published at: How to use the WORKDAY Function in Excel - Excelbuddy.com

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 datedays – Working days before or after…