Next, we add the difference between the end month and start month to get the remaining months between the dates. This gives us total months in the full years between the two dates. For that, we need to create our own formula.įirst, we subtract the start year from the end year and multiply the result times 12. Unfortunately, there is not a similar function to calculate months in Excel. This is a handy function for figuring out something like age when you have a birthdate. I'll plug in the dates we already have in columns B and C so you can see how it works. YEARFRAC returns the number of years between dates, including fractional years. The YEARFRAC function takes three arguments: start date, end date, and an optional parameter called "basis" that we'll ignore for now.
To calculate years between dates, we can use a function called YEARFRAC. This will give you some data to compare with the results of DATEDIF. To explain how DATEDIF works, the table below is set up to show all options available for Unit.įirst, however, let's calculate both years and months in a different way. Unit specifies whether you want the difference between dates in days, months, or years, with several variations. For reasons that are unknown, it's only documented in Excel 2000, but you can use it in your formulas in all Excel versions since that time.ĭATEDIF takes three arguments: start date, end date, and unit. The DATEDIF function is a "compatibility" function that comes from Lotus 1-2-3.
#EXCEL FOR MAC DATEDIF HOW TO#
In this video we'll look at how to calculate the number of years or months between dates using a function called DATEDIF and a function called YEARFRAC.
0 kommentar(er)
