Calculate Age in Excel ☑️

preview_player
Показать описание
Calculate Age in Excel using the Datedif Formula. You can find age of a person in excel i 2 ways
1 - Age of person as of today
2 - Age of person on a specific date

To find the age in excel the best way is to write the date of birth in a cell and the current date in another cell then use the Datedif Formula to calculate the DOB in Excel

Datedif Formula calculates the difference between 2 date in 6 variations.
“”d”” Days between the two dates.
“”m”” Months between the two dates.
“”y”” Years between the two dates.
“”yd”” Days between the dates, as if the dates were in the same year.
“”ym”” Months between the dates, as if the dates were in the same year.
“”md”” Days between the two dates, as if the dates were in the same month and year.

Learn Basic Excel Skills For Beginners || Part 1

10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel

5 Excel Questions Asked in Job Interviews

Create Speedometer Chart In Excel

Learn the Basic of Excel for Beginners || Part 2

Create Pareto Chart In Excel

How to Create Dashboard in Excel

Excel Interview Questions & Answers
Рекомендации по теме
Комментарии
Автор

I have watched so many videos of your sir. It is very simple and easy to understand. Thank you

Jishayaful
Автор

Sir one thing i wanna to say that your voice is perfect for Radio Jockey .. .. amazing superb. Hearts says to keep on listening

shekharasawara
Автор

learnt execl from you ..thankx buddy alot

SumitKapila
Автор

Sir, Kindly guide how to calculate exact age (if 6 months or more crossed after year then age should be come +1 in a cell by putting only dob

nikhilmahalaxme
Автор

Sir!
This formula is not working in MS Excel 2013 please sir guide me, thanks

saifmarwat
Автор

I have one excel doubt of data validation. I have questions in excel sheet. How i sent to u for help

RailLoVeRSaHaNi
Автор

Sir plz explain logic of formula in every video.

pihusati
Автор

My results keep getting a date instead of an age. For instance 9/27/18 (today's date) minus 5/17/04 (date of member) results in 1/14/1900

mikewellech
Автор

Datedif formula isn't working on 2018 version

little_India
Автор

Sir how to create year month week day hour minute seconds Formula

ToxicGaming
Автор

how the find which day on the day of birthday ?

lakeerajbhensdadiya
Автор

Can not get answer in "age as of" situation...what to do?

sagardoshi
Автор

Hello Sir, I'm doing the same thing which u told n your video, but i unable to get any positive result. plz tell me hw to do.
Thks & regards
Singh

manjindersingh
Автор

datedif formula doesn't work in my sheet

nizamkhan
Автор

2nd trick work nahi kar raha hai reff aa raha hau

rakeshnath
Автор

Sir ek excel file se password protection hatate hatate....file ka sare content delete ho gaya..how can i recover it

suvendukumarpanda
Автор

आपका फार्मूला काम नही कर रहा है। जैसे किसी जन्मतिथि को 23/5/1972 को 1/7/2017 निलालन है तो कैसे निकलेगा साल महीना दिन, जब आपके फार्मूले से निकल रहे है तो लिख रहा है । #valu! इसलिए समाधान बताइये

arvindkilife
Автор

Sir bhut pehle kr liya purana ha ye bhut kuch nya karao

jackychawla