I'm hoping this is going to be an easy one but not sure if it's at all possible.
In the attached simplified example, I want to enter a date in A2, enter a number of months in B2. For example, in the attached it shows 14 Apr 14 and 48 months. 48 months from 14 Apr 14 is 14 Apr 18. However, I need C2 to result in the last day of that month, i.e. 30 Apr 18.
Any help appreciated. (hope I've explained the above clearly).
Bookmarks