Calculate age using YEARFRAC in Excel - Excel Tips and Tricks

preview_player
Показать описание
Discover how to calculate age using your YEARFRAC function in Excel.

YEARFRAC is an Excel function that calculates the fraction of a year between two dates. By using this function, you can easily calculate a person's age in years, months, and even days. To calculate age, you simply need to subtract the person's birth date from the current date and divide the result by 365.25 (to account for leap years). This will give you the person's age in years with decimal places. You can then use the INT function to round down to the nearest whole number and obtain the person's age in years. Alternatively, you can use the DATEDIF function to calculate the number of complete years between two dates, but this function does not handle leap years as accurately as YEARFRAC.

Here are the steps outlined on the video.
1) =YEARFRAC(B3,TODAY())
2) Ctrl + 1
3) Number tab
4) Number
5) Decimal places set to 0

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips
Рекомендации по теме
Комментарии
Автор

This is not correct. If the result is for example 21.6, the age will show as 22.

aloobi