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).











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks