How to calculate age from date of birth Excel

preview_player
Показать описание
Learn how to calculate a person's age from their date of birth and the current date in Microsoft Excel.

Using two empty Excel cells, write down the date of birth and current date in separate cells, for example cell A1 and B1. On a third cell use the formula =INT((B1 - A1)/365) to convert the dates into an age.
Рекомендации по теме
Комментарии
Автор

Thanks. I like the lovely chirping birds too. Better than the noise some people put on.

pauls
Автор

4.2.2001 Date of my birth. If so, how old will I be in 2022?

saiqaislam
Автор

We can calculate like 2021- 2001 ?? Plz give reply

vanjarisaikarthik
Автор

How to know months with the help of this formula....?

biswakesansahoo
Автор

Sir one doubt piranthu oru year complete aana one age!?..yen age 28 years 5 months itha... Naa ennoda register marriage certificate apply panna 28 nu sollanumaa illa 29 nu sollanumaa....

padhroomsinger
Автор

Anna ennoda baby birth date 04/6/2019
Ipo papa ku evlo age...??
Ellarum 3 mudinjathunu Soldranga ...??
Birthday epo kondaduvinga 3 mudinjathunu kondaduvingla ila 3 age start aguthunu kondaduvingla hmm...???

little_rihana
Автор

I tried using this formulae, it resulted me error

sadanandkrishna
Автор

Simple calculation:
For example; 1990 - 2024 = 34

Alexa_Qavin
Автор

Kolantha poratha odaney age vanthruma clock wise thana 0 to 1 reach ana than 1o clk aguthu same 0 month la iruthu 12 month finish aana thana 1 athuku apro thana 1+ continue agi 2reach anathana 2 year tat gap tahana age

little_rihana
Автор

How to find age personality
Like 0-10 Children, 0-15 tenage

vanjarisaikarthik
Автор

Your answer itself is wrong....a person born in 1992 will be 25 years old in 2017 ..
..17years +8 years =25

vforvaishu