Calculate Age in Excel Hindi
HTML-код
- Опубликовано: 3 окт 2024
- Teach to each video on how to calculate age in excel hindi. This excel tutorial teach how to calculate difference between two dates with the help of Dated formula in excel hindi.
After this topic you will learn:-
1) Age calculation in excel
2) Difference between two dates in excel
3) Dated if formula in excel
DATEDIF : This formula gives the difference between two dates in the form of days, months, years.
Lets I explain you Datedif function in excel 2013,2013,2007 in hindi
Syntax of datedif function :-
=DATEDIF( start_date, end_date, interval )
Interval values in the DatedIF formula
Y - The number of complete years.
M - The number of complete months.
D - The number of days.
MD - The difference between the days (months and years are ignored).
YM - The difference between the months (days and years are ignored).
YD - The difference between the days (years and dates are ignored).
It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On youtube, only just few videos are available how to calculating age in excel hindi. Thanks for watching.
It is humble request to you. Please subscribe my RUclips channel by click on this link - / teachtoeach
Some popular videos-:
1) Pareto chart in excel hindi - • Create Pareto Chart in...
2) Drop down list from Different Workbook in Excel in Hindi - • Drop Down List from Di...
3) Pivot Table in Excel in Hindi - • Pivot Table in Excel i...
4) Create and Remove drop down list in excel in hindi - • Create and Remove Drop...
5) Vlookup with Indirect Function in Excel Hindi - • Vlookup with Indirect ...
6) Fuzzy Lookup in Excel Hindi - • Fuzzy Lookup in Excel ...
7) Text To Column in Excel in Hindi - • 🔥 Text To Column in Ex...
8) Vlookup with Match Function in Excel Hindi - • Vlookup with Match Fun...
9) Randbetween Formula in Excel in Hindi - • Randbetween Formula in...
10) Sort Left to Right in Excel Hindi - • Sort Left to Right in ...
11) Double Vlookup in Excel Hindi Part-2 - • Double Vlookup in Exce...
12) Array Formula in Excel Hindi - • Array Formula in Excel...
13) Excel vlookup formula error #NA #REF #VALUE in hindi - • Excel Vlookup Formula ...
14) 3 Tips to make easy Vlookup Formula in Hindi - • 3 Tips to make easy Vl...
15) Concatenate Formula in Excel Hindi - • Concatenate Formula in...
16) Double VLOOKUP in Excel Hindi - • Double Vlookup in Exce...
17) Split first middle and last name by using formula in excel hindi - • Split first middle and...
18) Create Dependent Drop Down List in Excel Hindi - • Create Dependent Drop ...
19) How to make a picture lookup in excel - • How to create a pictur...
20) Relative Absolute and Mixed Cell Referencing in Excel - • Relative Absolute and ...
21) Excel Logical Functions IF AND OR NESTED IF in Hindi - • Excel Logical Function...
Hey Viewers by Mistake ... I was used "YD" instead of "MD" .... So please if you are practicing then type "MD" to get Days in a month.
TeachToEach ...i was thinking same
Hi sir thanks for videos. You are a best teacher of Excel. Thanks again👍👍👍👌👌
In future be careful
Very very nice video 👍👍
I have never seen someone using the graphic with that much of good effect, good work..........and please keep it up.....
Welcome Rahul Ji
Very nice.
Thanks for the comment Shashikant Ji.
Nice formula and nice way to describe thank you so much.....
Thanks for the comment Deepak.
TeachToEach,,, I'm also a you tuber kindly watch a Story by me If u like plss subscribe me and share it to ur subscribers as well thanks
Thank you so much for providing me such practice sets
Welcome Partha
oppatel0207@gmail.com
bhai u r great person
I think you are great thats why you think i am also great. Daljeet Ji
Thanks
Nice video sir
Thanks for the comment Tarun.
awsm guru
Thanks for the comment Shailendra
Good morning sir,
Hi
Thanks. ; )
Welcome
Sir font kausa hai...jo use kiya hai..text mein...
Next cell me.. Aahish sir agar virat kohali ka age 29 years 5 months hai aur hume roundup karke 30 year lana hai to kya kare.. agar 29 yeas 4 months raha to only 29 years aana chyahiye..kya kare..
Sir ji..day 200 day jo aa rha h..
Use 30 se km aana chahiye or jaise hi 30 se jyda hoga 1 month pe plus ho jaye...
Yes I apologise for that .Already put the comment for this mistake at the top.
Nice
Thanks
Dateif function nhi active hai to kaise active karege
Hi Gaurav .... Dateif is a in-built formula in Excel. No need to active. Aap is formula ko direct likhte jaye ye kaam karega.
194 days ko bhi month me convert kaise kare.
Dear sir
Ya formula excel 2007 ma kya nahi kar raha ha formula lagana ka bad ma error dhak raha ha plz help me
Dear sir
Ye formula excel 2013 me kaam nhi kar rha h
Sir ye formula show hi nhi karta h
Plz help me sir
I always see ur vedio .
Daljeet Ji .... Maine video me bataya hai ki ye excel ka ek matr in-built formula hai jo hota hai par dhikhta nahi.
Aap type kare pura formula ex:- Datedif( .... jaise hi aap datdif likhne ke baad bracket "(" open karenge to aapko niche suggestion me dhikhega fir jaise maine apko bataya hai aap us tarike se use karlena ... Baki is video ka top comment padlena jo miane likha hai .... thodi se correction ko thik karne ke liye.
Daljeet Purohit 8
Nice sir
Good for help me
It's not working on office 2007
Bhai mere bivi me aur mere me eige ke bareme alag alag saval aa rahe he to bhai mere bachhe ki ege 19 - 3 - 19 he
to 19 - 7 - 2019 ko 4 tha mahina lagega ya khatam honga please Ripley
Hey admin 30Days equal to 1months so do as per it
Brother Saroj , Thanks for pointing out....Please check first comment on this video.
There is issue in value of days it should be below 31 days instead 200 days
Yes joy , Please read top comment on this video.
194 days is more than six months.
Sandip ji please read the first comment of this video.
days should be always less tham 31,30,29 and 28
Please read first comment of this video.
PLEASE mail me how to calculate in mob excel
Age nikalne k bad end date ko delete karte hai to age hi bigad jati hai.
Pehle paste special as values kardo uske baad delete maroge to nahi hatega
Why 194 days are not converted to Months.
Yes i know Ravi .... Plesase check first comment on my video
Give me job sheet
Sir
Ham excel me esaa nhi kr skte he ki excel kuch minute work naa kre to ham se password maage password enter krne ke baad me open ho jaae
Jesaa ki computer me kuch minutes ke baad sleep mode me chlaa jaataa he mouse/keyboard move krne pr logins password mhe enter krnaa pdtaa he wesaa hi excel me ho sktaa he yaa nhi
Contact number 9999531535 pawan
days to 29 se adhik to aa nahin sakta
Give me job sheet please
Goodnight
Sahre your EMail ID please
It's nice *Age* formula
Thanks for the comment Saurabh Ji.
Thanks
Welcome