Respected All,
I tried different methods, told by colleagues or shared by experts on different forums. But I was looking for a precise/accurate method to calculate number of months, days from a particular date to an ending date e.g. 1-Oct-2014 to 1-Sep-2015. I will use this information to make payments. Any support in this matter will be highly appreciated please.
Regards
For Months
=DATEDIF(D2,E2+1,"M")
For Days
=DATEDIF(D2,E2+1,"MD")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks ChemisB
Number of Months and Days are correctly counted using the formula you suggested.
I'm confused as to what to put the formula in I2 e.g. =(H2*F2)+(H2*G2/30) G/30 or G/31 or G/29, I wouldn't know. Could you kindly figure out and help me with it.
Regards
The formula
=(H2*F2)+(H2*G2/30)
is probably pretty good as an average. If you want to be exact
=(H2*F2)+(H2*G2/DAY(EOMONTH(G2,0)))
EOMONTH(G2,0) returns the last day of your final month (G2). Day pulls out that day (28,29,30, 31)
Great, Awesome.
That's what I was looking for.
Regards
Whoops! I put a DATEDIF solution in, too, since the 'page update' showed this was still unanswered. Then, when I added my comment, I saw all the other activity. Oh well.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks