The “start date” and “end date” are mandatory arguments, while “basis” is an optional argument. For “basis” equal to 1, 2 or 3,, or is calculated respectively.For “basis” equal to 0 or 4, is calculated as per the US or the European conventions respectively.It can take any of the following five values:

Basis: This is the basis on which the number of days is counted while calculating the fractional years.End date: This represents the ending date (current date) of the given period.Start date: This represents the starting date (past date) of the given period.The outputs of column C are shown in the following image.ĭescription of YEARFRAC function: The syntax of the YEARFRAC function is “YEARFRAC(start_date,end_date,).” The function accepts the following arguments: Next, drag the preceding formula to the remaining cells of column C. Note: For the syntax of the YEARFRAC function, refer to the “description of the YEARFRAC function” given at the end of this example. Step 1: Enter the following formula in cell C2. The steps for the same are listed as follows: So using this function we can find the year difference between two dates accurately. This function returns the difference between two dates infractions like 1.5 Years, 1.25 Years, 1.75 Years, etc. Working on the data of example #1, let us calculate the time gap (age) in fractions of years with the help of the YEARFRAC excel function YEARFRAC Excel Function YEARFRAC Excel is a built-in Excel function that is used to get the year difference between two date infractions. This is because the DATEDIF is a hidden function, which is not available in the Formulas tab of Excel.Įxample #2–YEARFRAC to Calculate Age in Fractional Years However, Excel does not help while entering the arguments of the DATEDIF function, unlike in the case of the other functions. The DATEDIF function works in almost all versions of Excel. Note: In the DATEDIF formula, the end date should always be greater than the start date. For row 2, the completed years between and are 4. This is because we have set the “unit” argument at “y,” which represents years. For “unit” equal to “md,” “yd,” or “ym,” the days (ignoring years and months), days (ignoring years) or months (ignoring days and years) are calculated respectively.Įxplanation: The DATEDIF function (entered in step 1) returns the completed years of age between any two specified dates.For “unit” equal to “y,” “m,” or “d,” the completed number of years, months or days is calculated respectively.It can take any of the following six values: Unit: This returns the time gap between the two dates in different units.End date: This is the last date of the given period.Start date: This is the beginning date of the given period.This is shown in the following image.ĭescription of the DATEDIF function: The syntax of the DATEDIF function is, “DATEDIF(start_date,end_date,unit).” The function accepts the following mandatory arguments: The outputs appear for the entire dataset. Drag the DATEDIF formula of cell C2 till cell C16.Hence, for the dates specified in row 2, the completed years of age are 4. The output appears in cell C2, as shown in the following image. read more function, refer to the “description of the DATEDIF function” given at the end of this example. This function's syntax is =DATEDIF (Start Date, End Date, Unit). Note: For details related to the DATEDIF DATEDIf is a date function that finds the difference between two dates, which can now be expressed in years, months, or days. Enter the following formula in cell C2.The steps to calculate the age in years by using the DATEDIF excel function are listed as follows: But, different formulas of Excel can be used for the same. It must be noted that Excel does not have a specific function for calculating age. The purpose of calculating the age is to study the period of survival of a person, event, project, corporate, and so on. In such cases, Excel can prove to be of help. However, in cases where this is not true, the complexities associated with the calculations increase. Type the formula without the starting and ending double quotation marks.Ĭalculating the time period is easy if the start and end dates represent the beginning and the ending of a month respectively. The formula “=DATEDIF(A1,B1,“d”)” returns 14 days. Besides age, one can calculate the duration of a project, the time gap between two specific dates, the years of existence of an organization, etc.įor example, one can calculate the number of days between (in cell A1) and (in cell B1). For calculating the age, the beginning and ending dates need to be specified. Age can be calculated in years, months, days, hours, and so on. In Excel, one can calculate the exact age of a person using different techniques.

Date calculator between two dates