Firstly, EDATE itself knows about month lengths and leap years: type 30/11/2015 into A1 and =EDATE(A1,3) into B1 and you will see this.
Can you explain clearly what you would expect 75% of three months to be? What date are you expecting your calculation above to return?
EDIT: I wonder if this is what you are looking for?
=EDATE(A1,ROUNDUP(B1*C1,0))
Last edited by AliGW; 08-23-2016 at 09:58 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Given that there is no finite number of days we can assign to represent 1 month, then trying to say 75% of 1 month will naturally be inherent with inaccuracies.
I think the closest we can get to a finite number representing 1 month is
(365.25*4)/48 = 30.4375
So if we multiply the number of months to add by 30.4375, then multiply that result by 75%
That's as close to accurate as you're going to get. I think.
So if
A1 = Start Date
B1 = Number of Months
C1 = Percentage
And assuming we would want to round the result of that calculation (to add an even number of days, instead of like 20.7432)
Try
=A1+ROUND(B1*30.4375*C1,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks