Tip: WORKDAY function in Microsoft Office Excel

WORKDAY function can be used to calculate end or start date of specific project. Why WORKDAY function can be helpful is because weekend and holidays can not be included in number of business/working days. Specific holidays can also be omitted.

• Syntax for WORKDAY function is: WORKDAY(Start_Date, Days, Holidays)
• Start_Date - the start date of your project
• Days - Number of days that your are going to work for the project. 
• Holiday - (optional) can be used to exclude one or more holidays from total working days.

Note: After applying the WORKDAY function, if you get answer in number format, you can change it to date format.

For that, first, select the cell; right click and click Format cells; select Date category from Format cells window.