Calculate Age in Excel | Get the AGE in Years from Date Of Birth in Excel | Age Calculator
Вставка
- Опубліковано 25 сер 2024
- #shorts in this video we will learn how to calculate age from date of birth in Microsoft Excel we are going to use datedif function to calculate age from date of birth to till date. we are going to use to function which calculates AGE from date of birth to any specific date which we mention in any cell in Excel and we are going to use today function to find out age as on today from any specific date. #excel #datedif #easyexplain #UA-camShorts #trending
Calculate Age in Excel | Get the AGE in Years from Date Of Birth in Excel | Age Calculator
Please make more such shorts man, I'm turning the notifications on for you!
Thanks so much 👌
Sure. You're Welcome. Keep Sharing 🔃
mujhe before or after one month, year ka date calculate krna hai then kya likhege "Today" ke jagah pe...
I did this but it shows error
Helpful short video.
Thank sir gaining knowleg
💞👌🏼
Keep Sharing 🔃
Thanks
You're Welcome. Keep Sharing 🔃♥️👍🏻
Wow so easy and clear..
I applied this today 😅
Thank you so much 🙏
Thank you so much...
Good info
You're welcome. Keep Sharing 🔃
thanku sir
Bro agr days mein krni ho to b sane procedure ha na
No then you have to Replace "Y" to "D"
Thanks ❤❤❤❤
You're Welcome
Aapka formula work nhi kar rha hai sir aap hme galt kyu bta rhe hai 😏😏
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
hi can u do for days calculate
Thank you so much sir btne ke liye
Any other option for today? Suppose I want to give tomorrow's date
We can also use YEARFRAC function to find Age,
=TRUNC(YEARFRAC(DOB,TODAY(),1))
trunc is applied to remove decimals fingure
"D" LAGAYA KAM HO GYA THANKS SIR
Date aur month dono me ek sath chahie to kya kare ?
please make advanced excel videos
Like?
@@EasyExplain would love to learn DAX functions. I visit your channel everyday to learn the lessons
Bhai nhi insert ho rha ...ye formula...#value errors bata rha h
Same here
@@SumitPatilharshu same
Same
Total 60 years service ke baad retirement date
Bro if date is not enter means how to print" no data ",possible bro
I did this but it show #value
Sir date our month ka komuniketion kar ke 15 se uper ho raha hai to formula kam nahi kar raha hai sir please
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
calculate like google
Bhai excel 2007 me ye function hi nahi hei
Hai or work bhi karta hai
सर enter लगाने पर Value लिखा जाता है बस
Thanks bro.
Tomorrow is my practical.
Sir no value dikha raha hai formula lagane ke baad bhi
Ctrl+1 press karke number format se date ya short date mein change karlo
Mene aaj hi try kya he formula date nd datevalue ka option aaya bs datedif to tha hi nhi ...what's wrong 😑😑😐
Nhi ho raha h mera
Don't work this one
harnoonr is that you :)
How to calculate age in year month day. Like 5yr 2month 6day.
Easy
this method you will like Google
=datedif(DOB,Current Date,"Y") Year ke liye
=datedif(DOB,Current Date,"YM") Month ke liye
=datedif(DOB,Current Date,"MD") Day ke liye
agar yeh janna hai ki din kaunsa tha to =text(DOB,"dddd")
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
Please
Kitne saal din or mahine kaise nikale
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
Sorry sir ni aa rha value
How to write dated of birth 07-09-1970
The same way you wrote here
Agar days Months aur years karna ho to?
=datedif(DOB,Current Date,"Y") Year ke liye
=datedif(DOB,Current Date,"YM") Month ke liye
=datedif(DOB,Current Date,"MD") Day ke liye
agar yeh janna hai ki din kaunsa tha to =text(DOB,"dddd")
Thanks
@@mahally_graphics thnx
@@Forgive.me007 You are very welcome brother
Nice 👍
You're Welcome. Keep Sharing 🔃♥️
Nhi ho rha h
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
Sir ye formula work nhi kar rha h 🙄🙄 value likh kar aa rha h
Calculate your age like google in excel
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
मोबाइल ऐप में बताओ 🥺🥺🥺
Sir ap 15/09/2002 ka years nikal kar bata digiye
You are 20 Years 5 Months 16 Days Old And you Born On Sunday
Excel ka equation hoga
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
Nahi aa raha h sir
Not working
Kahi job lagvado bhai
Mera ye formula ni lagta
Pls check office version
@@EasyExplain thanx lag giya tha
Nhi ho Raha bhai
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
excel age calculate issue
Please sir nahi nikal raha hai
=CONCATENATE(" You are ",DATEDIF(D.O.B,Current date,"Y")," Years ",DATEDIF(D.O.B,Current date,"YM")," Months ",DATEDIF(D.O.B,Current date,"MD")," Days Old "," And you Born On ",TEXT(DOB,"dddd"))
Wrong
Srif Galt information dete hai aap log report mar dungi ese chanal pe
Lan laa