There are a couple of ways to calculate the ages in year, but if you need to calculate the ages in month, the situation is slightly different. The number of days in a typical month could be any of the 4 numbers: 28, 29, 30 or 31.
If we count the days between the two dates and then divided by a certain number, we would get the number of months. However, that is not going to be very accurate because of the 4 variations.
One way to calculate the ages in month is to use the DATEDIF function, which counts the number of days, months, or years between two dates.
Please copy the following formula to calculate the ages in month.
=DATEDIF(A2, B2, "M")
Where A2 is the start date and B2 is the end date. "M" is the calculation type. Please refer to the table below for different calculation types.
|"Y"||The number of years|
|"M"||The number of months|
|"D"||The number of days|
|"MD"||The difference when ignoring the years and months|
|"YM"||The difference when ignoring the years and days|
|"YD"||The difference when ignoring the year|
Please note that this is to count the number of the full months between the two dates. For example, May 20, 2011 to April 1, 2012 is 10 months when using the DATEDIF function, even the actual days between is 11 days longer.