Forum Discussion
Solved
calculating months between two dates with rounding
I have been trying to look for the number between these two months while rounding to the next month if the day passes the 15th
With dates in A3 and B3:
=(12*YEAR(B3)+MONTH(B3)+(DAY(B3)>15))-(12*YEAR(A3)+MONTH(A3)+(DAY(A3)>15))
Calculate the difference between two dates
Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.
You can download an example workbook with all of the examples in this article.
You can follow along, or create your own formulas.