Excel - Calculate Age in Days, Months, or Years

preview_player
Показать описание
Learn how to use Excel's DATEDIF function to calculate age if you have a start and end date. The output can be days, months, years, or a combination.
Рекомендации по теме
Комментарии
Автор

is there a (relatively easy) way of calculating an age and working in formulas in YY.ddd format? As in 34 years and 212 days, etc.?

RobHolecko
Автор

I'm looking to calculate weeks and days for children data, is there a formula for this?

nohoracastro
Автор

how to find the age in days, month or years using today function by only giving one date as input?

aiyshwaryaaruchamy