Hi! I'm looking for a formula that will compare the months between two dates and provide an answer with decimal points. I'm currently using DATEDIF, but it's giving me whole months which can be a little misleading (i.e. Jan 15 2018 and March 14 2018 is returning a 1).
Any help is appreciated!!
Hi
DateDif by default always rounds down. What should the answer be? And how do you calculate the decimal when start and end months contain different numbers of days.
Did you look at this similar thread
https://www.excelforum.com/excel-for...a-decimal.html
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Yes, I have - I was hoping there's an easier solution in just getting the datedif to return a decimal number. I'm working with a large data set that feeds into a report and the formulas on that thread were quite large.
Is it possible to do something where if it's 16+ days more than the whole month it rounds up, less than it rounds down? So for example, comparing 03/05/2018 to 04/21/2018 would round up to 2 months, comparing 03/05/2018 to 04/20/2018 would round down to 1 month.
Maybe this work-around will help.
Assume start date is L1, end date is M1...
=DATEDIF(L1,IF(DATEDIF(L1,M1,"md")<16,M1,EDATE(M1,1)),"ym")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks