“D” – this will give you the total number of days that have passed between the two given dates.“M” – this will give you the total number of months that have passed between the two given dates.“Y” – this will give you the total number of years that have passed between the two given dates.But you can also use the below formula to do this (where the current date is automatically calculated using the TODAY function within the formula itself): = DATEDIF ( B1, TODAY ( ), "Y" )Īlso, let me give you all the other units you can use in the third argument of the DATEDIF function (we will be using these in the next section where we need to calculate age in years months, and dates in Google Sheets).īelow are all the values you can use in the unit argument in the DATEDIF function Note that I have used the current date as a cell reference (where I already have the current date in cell B2). In this example, I have used “Y”, which tells the formula to only calculate the total number of years that have elapsed between the two given dates. Unit – this is the argument that tells the DATEDIF function what needs to be calculated.End Date – this is the current date in this example.Start Date – this is the date of birth in our example.The below formula will calculate the age in the total number of years between the two given dates: = DATEDIF ( B1, B2, "Y" ) Let me first show you how to use the DATEDIF function. The first formula that you can use to do this is the DATEDIF formula (called the Date Difference formula), and the second one is using the YEARFRAC function. ![]() Now there are two formulas you can use to calculate the age in Google Sheets in years (i.e., to get the total number of years that have elapsed between the two given dates). Note that I have used the TODAY function to get the date of birth in cell B2. Suppose you have the dataset as shown below where you have the date of birth in cell B1 and the current date in cell B2. Calculate Age in Google Sheets – Number of Years, Months, and DaysĬalculate Age in Google Sheets – Number of Years.Calculate Age in Google Sheets – Number of Years.
0 Comments
Leave a Reply. |