Calculate Expiry Date with Excel Formula | or Calculate Maturity Date in Excel

In this video I demonstrate how to calculate expiry dates in Excel, based on the following:

1) Expiring after x number of days
2) Expiring after x number of working days (excluding weekends) using the WORKDAY function
3) Expiring after x number of complete months using the EDATE function
4) Expiring on the last day of x months using the EMONTH function
5) Expiring on the first day of month after x months using the EMONTH function
6) Expiring after x years exactly using the DATE, YEAR, MONTH and DAY functions.
7) Expiring after x years on the last day of previous month using the DATE, YEAR and MONTH functions.
------------------------

[IvanCortinas_ES]

Great video. Date functions are very important in Excel. Thank you Chester!

[zabedalam]

Iam trying to subtract days it's showing value errors