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:
It’s changing the day 22 to 27 instead of year. The required answer is: 22-04-2020.=IF(M4="","",M4+5)
Any help will be highly appreciated.
Thanking you,
Bookmarks