I went through a lot of forums and was not able to find the solution for my problem.
Problem: I have a start date, let's say 23-08-2016. If I want to add 3 months, I could just use edate(A1,B1). However, the number of months depends on a success rate, let's say 25%. The problem is that edate(A1;B1*C1) will assume that the number of months is 0,75 (3 months * 25%) and will round to 0 months.
An extra difficulty is that if my start date is February and I would like to add 0,75 months (or other value), then the formula should now that February has 28 (or 29) days, April 30 days, May 31 days and so on.
A1: 23-08-2016 | B1: 3 | C1: 25%
I tried datedif, offset, and others, and was not able to achieve any good results, because the end date varies according to the month of the start date.
Any help would be much appreciated.
Thank you
Bookmarks