How to Calculate Age from Date of Birth in Excel || Age Calculation from DOB in Excel || Datedif ||
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- After watching this video you will be able to know how to calculate age in MS Excel in very easy manner.इस वीडियो को देखने के बाद आप जान पाएंगे कि एमएस एक्सेल में उम्र की गणना बहुत ही आसान तरीके से कैसे की जाती है।
#creatingforindia
#ageinexcel
#excel
Please us this formula for more accurate result.
=(today-dob)-30
then use formatting as described in the video
How to Calculate Age in Excel || Age Calculation in Excel || Age Calculator in Excel || Age in Excel
Join this channel to get access to perks:
/ @excellent24
Topic covered:-
how to calculate age in excel
age calculation in excel
age calculator in excel
age in excel
how to make age calculator in excel
how to calculate age in excel 2003
age calculation in excel 2003
age calculator in excel 2003
age in excel 2003
how to make age calculator in excel 2003
how to calculate age in excel 2007
age calculation in excel 2007
age calculator in excel 2007
age in excel 2007
how to make age calculator in excel 2007
how to calculate age in excel 2010
age calculation in excel 2010
age calculator in excel 2010
age in excel 2010
how to make age calculator in excel 2010
how to calculate age in excel 2013
age calculation in excel 2013
age calculator in excel 2013
age in excel 2013
how to make age calculator in excel 2013
how to calculate age in excel 2016
age calculation in excel 2016
age calculator in excel 2016
age in excel 2016
how to make age calculator in excel 2016
how to calculate age in excel 2019
age calculation in excel 2019
age calculator in excel 2019
age in excel 2019
how to make age calculator in excel 2019
how to calculate age from date of birth in excel
how to calculate age from date of birth
how to calculate age from dob
how to calculate age from date of birth in excel
how to calculate age from date of birth
how to calculate age from dob in excel
how to calculate age from dob in ms excel
age calculation from date of birth in excel
age calculation from dob in excel
age calculation from date of birth in ms excel
age calculation from dob in ms excel
how to calculate age from date of birth in excel 2003
how to calculate age from date of birth 2003
how to calculate age from dob in excel 2003
how to calculate age from dob in ms excel 2003
age calculation from date of birth in excel 2003
age calculation from dob in excel 2003
age calculation from date of birth in ms excel 2003
age calculation from dob in ms excel 2003
how to calculate age from date of birth in excel 2007
how to calculate age from date of birth 2007
how to calculate age from dob 2007
how to calculate age from date of birth in excel 2007
how to calculate age from date of birth 2007
how to calculate age from dob in excel 2007
how to calculate age from dob in ms excel 2007
age calculation from date of birth in excel 2007
age calculation from dob in excel 2007
age calculation from date of birth in ms excel 2007
age calculation from dob in ms excel 2007
how to calculate age from date of birth in excel 2010
how to calculate age from date of birth 2010
how to calculate age from dob 2010
how to calculate age from date of birth in excel 2010
how to calculate age from date of birth 2010
how to calculate age from dob in excel 2010
how to calculate age from dob in ms excel 2010
age calculation from date of birth in excel 2010
age calculation from dob in excel 2010
age calculation from date of birth in ms excel 2010
how to calculate age from date of birth in excel 2013
how to calculate age from date of birth 2013
how to calculate age from dob 2013
how to calculate age from date of birth in excel 2013
how to calculate age from date of birth 2013
how to calculate age from dob in excel 2013
how to calculate age from dob in ms excel 2013
age calculation from date of birth in excel 2013
age calculation from dob in excel 2013
age calculation from date of birth in ms excel 2013
age calculation from dob in ms excel 2013
age calculation from dob in ms excel 2013
how to calculate age from date of birth in excel 2016
how to calculate age from date of birth 2016
how to calculate age from dob 2016
how to calculate age from date of birth in excel 2016
how to calculate age from date of birth 2016
how to calculate age from dob in excel 2016
how to calculate age from dob in ms excel 2016
age calculation from date of birth in excel 2016
age calculation from dob in excel 2016
age calculation from date of birth in ms excel 2016
how to calculate age from date of birth in excel 2019
how to calculate age from date of birth 2019
how to calculate age from dob 2019
how to calculate age from date of birth in excel 2019
how to calculate age from date of birth 2019
how to calculate age from dob in excel 2019
how to calculate age from dob in ms excel 2019
age calculation from date of birth in excel 2019
age calculation from dob in excel 2019
age calculation from date of birth in ms excel 2019
age calculation from dob in ms excel 2019
age calculation from dob in ms excel 2019
Although easy but it shows incorrect number of months. It shows one month count extra. Pls check. I feel "datedif" formula gives accurate results.
That's true....it was intentionally done....want to know how many of my viewers can find out....I have a perfect solution for it. I will let you know soon then you will forget datedif.
BTW thanks for your valuable feedback ☺️
Btw thanks for your valuable feedback
Yes it is wrong and gives one month extra
What if I don't have Datedif in Excel
Mere Excel me Datedif he hi nahi ab kya kare
-30
Easiest trick ever
Bade bade TH-cam channel ne nhi batayi esi trick
Thanks 👍
I tried to make difficult task to easy
Very Nice, thanks for supprot 👍👍
Most welcome keep watching
Wah wah wah 👍
Thanks 👍
Wah wah
Shukriya
Fantastic🤘
Thanks for your valuable feedback ☺️
Freeze kaise karna hai
Video dobara dekhiye
Awesome 😎
Thanks
Jab ham 1 se zyada cells ko koi color fill karte he to lines (rules) gayab ho jati he? Plz help
Mein samjha nahi aapki baat... please explain in details
Sir ,output nhi aa rhi proper..aap ne years,month and day ke liye koi aur formula use Kara hai? details mein btaye.
Nahi jo video me bataya he wahi follow Kiya he...ap video ko dobara dekhiye fir apply kijiye....agar fir bhi koi dikkat aati he to mujhe info.ecs123@gmail.com par mail kijiye
Freege kaise kiya aapne sir pls btao
Press F4
@@Excellent24 thanks🙏
@@Excellent24 yha nhi ho rha sir glt btaya aapne sir
Aap video dobara dekho usme jitni baar F4 press karne ko kaha he...wese karo
@@Excellent24 dekhte h sir
Sir mostly toh sara thk tha... Pr month m ek month extra count hora h
pls check description for accurate formula
th-cam.com/video/6Op8xzZpij8/w-d-xo.html
Is there any other video?? For make this correct
th-cam.com/video/xYJA5qoJwEo/w-d-xo.html
th-cam.com/video/6Op8xzZpij8/w-d-xo.html
How to freeze a date
Use F4
Freez kaise karte hai
press F4 key
It shows incorrects number of months
Please check description
Formula dosent work, month is showing extra
Yes, but you should use a formula given in the description for accurate result
Sir hi freeze ka mtlab
Formule me is cell ya row ya column ko fixed kar dena hi freeZ hota he
Pl show me how to freeze date
Press F4 for freezing
How to freeze that date?
Press F4 for freezing
Not done
Please check description
Bhai freeze kaise karna h
F4 key press karo
Thanks bhai
Hua nahi kuch bhai
Video dhyan se dekho fir apply karo
Freeze nahi ho raha leneo ka laptop hai
it is not correct formula
It gives one month extra please follow description
th-cam.com/video/6Op8xzZpij8/w-d-xo.html