![]() ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |