How To calculate difference between two dates in excel Hindi || in Number Of Years/Months/.Days

[@gospelverace]

Abhi Maine aapne jaisa sikhaya, kiya aur ho gaya. Aur tareeka bhi malum ho gaya. Dil se dhanyawaad.

[@ashutoshsrivastava3877]

sir aap to bhut ache master ho aap se Acha master to koi h hi nhi sir waooo very nice knowledge video....

[@DeepakEduWorld]

thanks g

[@RajeshKumar-wh7gc]

Sir aap ka excel shikhane ka tarika aalag hi hai thinks for addvions knowledge ke liye

[@lmyers0804]

So easy to understand that I did not even know the language he is speaking. Top-notch demonstration!! I subscribed.

[@sahilsachdeva5303]

Speaking Hindi😍

[@bhatmushtak5912]

You are really great,a true excel expert

[@Kimyun-oq9qy]

Simple and super with detailed information

[@LikeDislike83012]

Thanks Sir yeh Experience Kay liye kaam aa Gaya Experience aur Date birth Kay liye

[@dakshkumar873]

Tahnk you Sir.
Aapne bahut acche se sikhaya.

[@belikebhai]

बहुत बढ़िया वीडियो, सबसे सरल, सबसे आसान।। धन्यवाद शुक्रिया

[@Unseentrails]

Thanks bro aapne mere 3din ke work ko 3min me krwa diya aur kuch naya sikha bhi diya

[@akramansari5317]

It's like you created new formula.

[@AnilKumar-co3mx]

Bhut hi useful and save our time

[@shyambhaskar4835]

Great help .....it helped me a lot in work..MACT calculations....I would like to add that a problem may arise in entry of dates ....
Pls follow
On the cell to input date
Right click to go format cells
In that go to date and enter the first mode
See that country region and type of calendar is not changed
Now repeat the same settings in the other cell in which you input the second date
Then go on with the formula

[@shabrotherss]

Very very informative.... Thanks a TON

[@bishtrajan969]

Gajb bhai gajab..
Ye to koi bhi bata sakta hai lekin batane ka tarika bahut khubsurat hai..
Voice bhi achi hai aapki... Keep it up bro

[@mazharsiddiqui4567]

दोस्त आपके समझाने का तरीका अच्छा यदि में गलत नहीं हूं आप साइंस साइड के स्टूडेंट् हो मैं आपकी सभी वीडियो देखता हूं समझाते ऐसा हो कि वीडियो दोबारा देखना नही पड़ता एक बार मैं माइंड में फिट सेट हो जाता हैं

[@DeepakEduWorld]

+Mazhar Siddiqui MASTER IN TECHNOLOGY... M. Tech...

[@MrPZAHOOR]

Kamal ka formula Deepak Sir,

[@shreesantgulabraomaharaj2480]

मैं भी शुरूमे उसको डेटेड इफ ही बोलता था लेकिन मुझे लगता हैं कि वो डेट डिफ हैं। आपके एक्सेल के वीडियोस मुझे सबसे ज्यादा पसंद आते हैं। कुछ जगह स्पेलिंग मिस्टेक होती हैं। मुझे कोई फरक नही पड़ता। मुझे केवल एक्सेल सीखने से मतलब हैं। कुछ लोग बोल सकते हैं।

[@Digitalck]

Very good trick sir ji.

[@mohitnamberdar2391]

Very very.........nice yur.....vidio

[@vishnusankpal6998]

Thank you sir , it is very useful formula and also you have saved us one app memory.

[@Parimal_Asodiya]

અદ્ભુત , તમારો ખુબ ખુબ આભાર , સાહેબ

[@NavneetKumar-wf4pl]

SO Wandrful FULL ♥️♥️♥️♥️♥️♥️

[@CSAlish_Dodhia]

Thnak u bro :)

[@alokmandal6643]

Liked the vedio...too much...thankyou

[@nehajagdev2383]

thanks very helpful video.

[@durgimajhi1629]

Nic formula , sir.......

[@dhansayyadav7085]

दो तिथियों के अन्तर को आपने बड़े अच्छे ढंग से समझाया , धन्यवाद , किन्तु एक समस्या को कैसे हल किया जायगा ------ आपने वर्ष को वर्ष से , माह को माह से , तथा दिन को दिन से घटाया पर यदि जिस दिनांक को घटा रहे है उसका
दिन व ,माह बड़ा हो तो कैसे घटाएंगे जैसे ---- 09 /10/1999 में से 26 / 11/ 2015 यहाँ दिन माह वर्ष के क्रम में दिनांक लिखा गया है.

[@DeepakEduWorld]

Okay g.. I will publish video shortly

[@dhansayyadav7085]

आपने हमारी समस्या को संज्ञान में लिया आपका बहुत बहुत धन्यवाद , अब बस इन्तजार है .

[@kirandeepchoudhry9232]

Sir, apne computer keyboard date format ko badal de text to column se

[@kirandeepchoudhry9232]

Shayad ho jaye

[@nyeembashar1659]

Thank you. I was looking for this..

[@rajkumarnirmalkar7906]

Good 👍👍👍

[@rameshwernagar1599]

शानदार bro

[@venkateshkademane2098]

Great sir
This was I was searching for yesterday

[@sumitnimbal7507]

Very nice so helpful

[@DeepakEduWorld]

🤗

[@pankajknowledgeworld]

Video aap detail main banate ho it's nice efforts
. Bus ish video main last main message print wala add kar dete ki aaj birthday hai ya पांच दिन बाद birthday aa rahe hai. Get ready toh aur maja आती

[@Jachaurasia27]

Awesome technique really helpful

[@paruljoshi3770]

Very useful 👌👌👌

[@onlypattanaik8251]

Thanks a lot

[@electricus_aniruddhachanda8184]

Thnx a lot Sir G. Sir kindly explain 1 more thing in details, that is the Date Format, which you have apply hear in this video and the topic , "business day" is also very important.

[@khalil7337]

Super trick brother

[@debjyotighosh2414]

IT IS VERY HELPFUL...THANKS..

[@rahulmanoharan9746]

Thanks Deepak. Good job

[@DeepakEduWorld]

😊

[@AftabAhmed-uw4ki]

Very nice sir I am expert I after see this video okay bye

[@rahultiwari9251]

Bahut badiya thanks sir

[@KiranKumar123Go]

Thanks Brother 🙏

[@sujeetrajpoot2183]

thank you. its helpful in my job

[@RameshPal-cd4cs]

Very impressive and good.

[@hashimsiddiqie8960]

Very nice

[@jayjawanjaykisan7105]

Very useful video .
Thanks

[@IrfanKhan-lq9zz]

Great sir
Like always

[@gorakhanathk5054]

Fantastic. "datedif()" formula is not in excel library, still it works!!!. AMAZING! That means wwe can define our library also?

[@DeepakEduWorld]

👍😊

[@devkum2733]

sir you give your best

[@APNIMANJIL]

Very useful formula thanks so much.

[@snshaan]

You don't need to do so much just use this formula directly,
=DATEDIF(B7,TODAY(),"Y")&" Years "&DATEDIF(B7,TODAY(),"YM")&" Months "&DATEDIF(B7,TODAY(),"MD")&" Days"
Change "B7 & TODAY()" with your following dates as per to your respective cells.

[@atanuroy3548]

Thanks for your information

[@KiranKumar123Go]

Yes this Correct one 👌. Good Job

[@pupaimalik6189]

Days formula isn't working. What should I do?

[@zaibkhan6834]

Sir very informative video I like it very helpful for me thank you sir sooo much from Pakistan at Karachi

[@venkateshkademane2098]

Great brother❤

[@rajeshshah6758]

Great Sir creating something different from the regular.

[@ssr6526]

Yes badhiya hai ye formula

[@bijaytanty8434]

Thanks Sir

[@burhanahmad5895]

Very helpful.

[@prashantkumar-op8jt]

You are great Sir, Please meet me

[@parwejcomputereducation9459]

Superb sir

[@anusuyamahariya8980]

Nice.. Very helpful
Sir yadi en date m se RBI Holidays minus karne ho (each Sunday and second Saturday) to kaise kare

[@yaspalsingh5028]

Very nice brother

[@abhishekpathak2751]

Very very helpful.......

[@rajkumarsoni7683]

Thanks mujhe yah bahut din de dundhne par mila but जिसे aapne hide किया उस कालम के बिना ही क्या years, month, day ka chart banaya ja sakta hai.

[@pranjalinagpure1292]

Very helpful

[@e_sgaming3598]

Very good bro.
Nice i watch yours videos

[@stivenguzman3845]

Thank you

[@payalkashyup4587]

Thanku so much sir 👍👍⛄ ⛄☺☺

[@DeepakEduWorld]

+Payal Kashyap 👍

[@ghurahuprasadyadav3798]

Fantastic tips sir

[@Anuragrajpoot94]

Very nice video

[@puravkansal7424]

Great work...plz improve video quality. Screen is not visible clearly. Thanks

[@rjdr6014]

Deepak ji, your tutorials are mind blowing - yet so easily explained.
I hope you can help me solve my little problem.
If I want to know that which month and year will come after 591 days from today - is there any formula in excel which will show it?
e.g if today is 13.11.2022
- after 623 days it will be 28th July 2024 (Sunday).
Can excel tell me that? In that format? even 28.07.2024 will do.
If yes - Please tell me - how?

[@rjdr6014]

Got this reply from another post - hope it may help someone with my problem -
"Format the cell with the formula in it to whatever date format you want.
Formula is then =today()+591.
If you want the exact date format shown in your question, you can set up a custom format of dd.mm.yyyy"
Any other method from your end will also be helpful.
Thanks Deepak ji.

[@Pammirakeshsingh123]

Thank sir

[@seetalkumar2831]

Hi ! Sir! Thank you for uploading this video which is very useful. I am getting error code '#NAME?' while using this in MS excel 2010,

[@technodex8678]

same the formula dont exits do we need to set it manually any help

[@ITCE2018]

So useful, very clear voice and explanation is good

[@gotamsindhi5277]

Excellent sir

[@COD401gaming]

Good job

[@sureshnagwan7805]

Excellent

[@vinaykaushik8831]

Thanks!

[@mallikarjunabagali9001]

Hi sir your videos wonderful sir thank you very much muje ek Excell me problem araha hi plz solve today 14/05/2021 hi next 100 days ko date Kya anewal hi formate videos banayi ye plz

[@TECHBOY-zd8xs]

Make short video...... To teach just date difference you took 15 min.......

[@krishnavenimitta574]

Thank you sir

[@ritulad3125]

Thanks

[@9820590961]

v nice

[@someshwarbose]

Nice...thank you

[@mdadivision4569]

Sir, you are doing excellent job. pl. give the download link also

[@kapiljoshi2321]

Thansk buddy

[@knowledgeabc0903]

Thank you, excellent

[@mahendrapatil2857]

i like it all videos about exel

[@raazshortapptrick5736]

good, and Thanks

[@nitinsoni4299]

Sir at last apne 3 different dates ke bitch mein year,month and date batya hai if un sare year,month and days ka sum karna ho to kar sakte hai kya

[@tarnaka504]

Nice.

[@vishalchandrani2962]

Nice video... I have a list of student with date of birth if any student is overaged than the asking age or age limit than how to identify the student plz share video...If the student is between asking age show with valid n if overage show invalid
Thanking ...

[@arvindpatel4249]

Ek hi column percentage ke sath kisi digit se divide kar sakte

[@arunkumarkumbhar2806]

Will be obliged to know the formula calculating week - day difference between two date's.Thanks

[@sarlakumbalpuri8779]

Sir too good

[@thebaharcadetschool]

Sir tell about underage and overage formula in excel

[@yadavrahul9782]

Nice sir

[@arvindgirigauswami2196]

Well done sir

[@DeepakEduWorld]

thanks

[@bhaskarmukherjee7889]

Hi Sir, is there any way in Excel to write number into words.