1] Add days directly If the expiry period is defined in days, you can calculate the expiry date by simply adding the number of days to the starting date using the + operator.

If you need to count or calculate number of Leap Years between two dates in Excel or list of two dates in Excel, make use of this formula to get things done.