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))
I tried this formula and unfortunately, it didn't work. The formula hans gave seems to work
how would I change the format of the cell
- Select cell or range of cells
right mousekey
Select "Format Cells...".
Numbers -> Set to "Default".
