Hi friends,

I want to get a maturity date after 5 years.
The date of issue is in range ‘M4:M25) respectively.
The due date is in range ‘R4:R25’ respectively.

For ex.

Date of issue .. Due date
22-04-2015 .. 22-04-2020

The formula is:

=IF(M4="","",M4+5)
It’s changing the day 22 to 27 instead of year. The required answer is: 22-04-2020.

Any help will be highly appreciated.

Thanking you,