Question: how to calculate end date in excel?
Answer: Workday: Returns the serial number of the date before or after a specified number of workdays. ... 
Syntax: =WORKDAY(start_date,days,holidays)
start_date: It is the date that represents the start date.