How to calculate age from date of birth Excel

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.

[@pauls7056]

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

[@SandeepSingh-iz5qd]

Very precise and clear........ Nice content

[@saiqaislam87]

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

[@vanjarisaikarthik4030]

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

[@d.rmemories6918]

Thank you brother great work😇

[@amruthabodi9055]

1999 may means now how much age??

[@r_69_tejaswinimahajan14]

21

[@akshayhannikeri3775]

@@r_69_tejaswinimahajan14 22 as of the time when you commented.. And 23 as of now.. 2022

[@little_rihana]

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...???

[@padhroomsinger5342]

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....

[@biswakesansahoo6190]

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

[@good2know23]

kzbin.info/www/bejne/j3uYXq2VnpqhmZY

[@little_rihana]

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

[@sadanandkrishna5296]

I tried using this formulae, it resulted me error

[@vinaykaduk7558]

2003 may month means how much my age?

[@omar_vlogger]

18

[@Alexa_Qavin]

Simple calculation: For example; 1990 - 2024 = 34

[@jailsonshakur6948]

THANKS

[@Subbaiah85]

SUPER

[@vanjarisaikarthik4030]

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

[@karthick3597]

Tq ji

[@shinushinu6968]

22/8/1980 now how much my age

[@bromevlog.4324]

3/27/2000 how much my age?

[@rekhamothay1813]

20/3/24

[@vforvaishu8030]

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

[@akshayhannikeri3775]

Yes he is totally wrong.. Actually it is approximately 24 years 11 months OR round it off to 25.. But definitely not 24 exactly

[@abiabisha.r6753]

Ada pongada neengalum oonga vayasum