Drag down theFill Handletool toAutoFillthe formula for the rest of the cells. You will get the age values inmonths. Select cellE5. Enter the following formula: =D5/12 PressENTERto get the age value for theyear. Drag down theFill Handletool toAutoFillthe formula for the rest of the cel...
You can also use the YEARFRAC function to calculate the age in Excel (in years) in the specified date range.Here is the formula:=INT(YEARFRAC(B1,TODAY()))The YEARFRAC function returns the number of years between the two specified dates and then the INT function returns only the integer ...
To calculate someone's age in years, use Excel'sDATEDIFfunction. This function takes the date of birth as an input and then generates the age as an output. For this example, we'll use the following spreadsheet. In the spreadsheet, the date of birth is specified in the B2 cell, and we...
Case 1.2 – Calculating Age in Months Steps: Select cellD5and insert the formula below: =DATEDIF(B5,C5,"m") CellB5represents the start date, whereas cellC5represents the end date. We insertedmas the unit because we’re looking for the difference in months between the two dates. Hit theE...
Basic Excel formula for age in years How do you normally figure out someone's age? Simply by subtracting the birth date from the current date. This conventional age formula can also be used in Excel. Assuming a birthdate is in cell B2, the formula to calculate age in years goes as foll...
Again, for this example, to calculate age in Years and Months where the dates are in column B, the final formula would be: =DATEDIF(B2,TODAY(),"Y") & " Years and " & DATEDIF(B2,TODAY(),"YM") & " Months" Performing the Same Calculation Using DATEDIF ...
This option will calculate the current age for the selected date of birth. In other words, it will compare a person's birthday to the present day. Calculate age on aSpecific date. This option lets you get Excel formula to calculate age between two dates: the date of birth and any date...
1.12 Calculate months ignore years and days between two dates If you just want to calculate the months difference ignoring years and days between two dates as the below screenshot shows, here is a formula that can help you. =DATEDIF(A2,B2,"ym") ...
The complete formula will be: =DATEDIF(B2, TODAY(), "y") This formula calculates the difference in years between the date of birth (cell B2) and the current date. How To Calculate Age from Date of Birth in Months You can calculate a person’s age in Excel from their date of birth ...
Formula 1: The INT Function The first method is to count the days between the two dates and divided by 365.25 for the years, then use the INT Function to extract the integer as the age in the year. =INT((B2-A2)/365.25) "B2-A2" is to count the days between the two dates. ...