HKR Trainings
The WORKDAY function in Excel is a DATE function used to calculate the work date coming after a given number of days from the start date. In addition, this function has an optional argument for holidays which, if not provided, automatically considers the weekends, Saturdays, and Sundays, as holidays and calculates the future work date after a given number of days. The method to use this function in Excel is as follows =WORKDAY ( Start_date, Days, Holidays). The first two arguments are mandatory; however, the argument for holidays is optional. A WORKDAY function is categorized as a DATE/TIME function in Excel that returns the date after or before a specified number of working days, excluding the weekends and holidays. A workday in Excel is a very efficient function used for calculating working days, due dates, Excel Gantt charts preparation, workday scheduling, computation of the number of workdays of an employee, and other financial analysis.