I'm using this formula =DATEDIF(B2; C2; "M")
on Googles spreadsheet to calculate months.
I expected when entering a begindate B2
22-4-2013 and enddate C2
31-8-2014 to get an exact result: 16,3397.
Unexpected result is only full months 16.
google sheetsgoogle-sheets-dates
I'm using this formula =DATEDIF(B2; C2; "M")
on Googles spreadsheet to calculate months.
I expected when entering a begindate B2
22-4-2013 and enddate C2
31-8-2014 to get an exact result: 16,3397.
Unexpected result is only full months 16.
Best Answer
You asked for
Also in my question on how you came up with the number
16,3397
you saidSo this is the formula you should be using
You can also use
We use
C2+1
to also count the last day as well.The way Google counts, it does not take in account the last day.