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

[@RajeshKumar-wh7gc]

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

[@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

[@dakshkumar873]

Tahnk you Sir. Aapne bahut acche se sikhaya.

[@LikeDislike83012]

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

[@bhatmushtak5912]

You are really great,a true excel expert

[@Unseentrails]

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

[@lmyers0804]

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

[@sahilsachdeva5303]

Speaking Hindi😍

[@Kimyun-oq9qy]

Simple and super with detailed information

[@KPBHAIG]

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

[@mazharsiddiqui4567]

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

[@DeepakEduWorld]

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

[@akramansari5317]

It's like you created new formula.

[@shreesantgulabraomaharaj2480]

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

[@MrPZAHOOR]

Kamal ka formula Deepak Sir,

[@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

[@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

[@vishnusankpal6998]

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

[@shabrotherss]

Very very informative.... Thanks a TON

[@anusuyamahariya8980]

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

[@rajkumarsoni7683]

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

[@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

[@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.

[@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

[@ranjeetverma2720]

sir mera ek question h ki agar exl me 01/06/2018 se lekar 23/10/2018 tk hmne bill ke amount ki intri series wise ki hui h to hmko usme se 01/09/2018 se leke 01/10/2018 tk ke bilo ka amount hi janna h to uske liye konsa formula use krenge aapke jawab ki prtixa h. Dhanywad

[@DeepakEduWorld]

kzbin.info/www/bejne/e4mVi5Sej5ijftE

[@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 आती

[@Parimal_Asodiya]

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

[@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.

[@nehajagdev2383]

thanks very helpful video.

[@nyeembashar1659]

Thank you. I was looking for this..

[@Digitalck]

Very good trick sir ji.

[@venkateshkademane2098]

Great sir This was I was searching for yesterday

[@AftabAhmed-uw4ki]

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

[@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?

[@alokmandal6643]

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

[@debjyotighosh2414]

IT IS VERY HELPFUL...THANKS..

[@APNIMANJIL]

Very useful formula thanks so much.

[@sujeetrajpoot2183]

thank you. its helpful in my job

[@durgimajhi1629]

Nic formula , sir.......

[@Jachaurasia27]

Awesome technique really helpful

[@RameshPal-cd4cs]

Very impressive and good.

[@NavneetKumar-wf4pl]

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

[@jayjawanjaykisan7105]

Very useful video . Thanks

[@CSAlish_Dodhia]

Thnak u bro :)

[@sumitnimbal7507]

Very nice so helpful

[@DeepakEduWorld]

🤗

[@zaibkhan6834]

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

[@venkateshkademane2098]

Great brother❤

[@mohitnamberdar2391]

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

[@arvindpatel4249]

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

[@puravkansal7424]

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

[@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 ...

[@gorakhanathk5054]

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

[@DeepakEduWorld]

👍😊

[@e_sgaming3598]

Very good bro. Nice i watch yours videos

[@rahulmanoharan9746]

Thanks Deepak. Good job

[@DeepakEduWorld]

😊

[@KiranKumar123Go]

Thanks Brother 🙏

[@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

[@rahultiwari9251]

Bahut badiya thanks sir

[@pkshah2606]

aapka video dekha acha laga kuch naya sikhne mila. maine bhi try kiya lekin meri ek querry hai jab mai for e.g. start dt 01-10-17 end date 31-10-17 leta hoo or formula me unit "M" leta hoo to result 0 aata hai lekin ye galat hai actually one month hona chahiye wo shayad month to month calculate karta hai isliye 0 bata raha hai lekin fir calculation wrong ho jayega. please guide me what to do

[@paruljoshi3770]

Very useful 👌👌👌

[@khalil7337]

Super trick brother

[@onlypattanaik8251]

Thanks a lot

[@devkum2733]

sir you give your best

[@rajeshshah6758]

Great Sir creating something different from the regular.

[@prashantkumar-op8jt]

You are great Sir, Please meet me

[@rajkumarnirmalkar7906]

Good 👍👍👍

[@TECHBOY-zd8xs]

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

[@bhaskarmukherjee7889]

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

[@hashimsiddiqie8960]

Very nice

[@marutishinde309]

Hello Sir मुझे महिने के हिसाब से दिन निकलने hai जैसे की अगर हम किसी month का नाम डाल दे तो उसके पुरे दीन कितने है वो निकलना चाहीहे कैसे करें

[@Rajvibadodiya]

Video start from 2:38

[@ITCE2018]

So useful, very clear voice and explanation is good

[@IrfanKhan-lq9zz]

Great sir Like always

[@AJ.ZARRAR.GAMING]

It na asan hy maloom nahi tha

[@arunkumarkumbhar2806]

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

[@rameshwernagar1599]

शानदार bro

[@abhishekpathak2751]

Very very helpful.......

[@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

[@yaspalsingh5028]

Very nice brother

[@burhanahmad5895]

Very helpful.

[@akakarun8]

Excellent. Is there any way to get only business days (5 Days Mon-Fri) instead the calendar days?

[@mdadivision4569]

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

[@ssr6526]

Yes badhiya hai ye formula

[@chandreshsoni1047]

Required help for this type of formula that I want to count current month also I.e. start date 1/1/20 end date 15/7/20 which shows 6 months only but I want to count 7 month also so how can I do bro ?

[@PradeepKumar-yp3tc]

Do we have a function or a way to get tenure of employees if yes then please make a video on this

[@chetanpathak4686]

Sir Can you guide how to find due date. Emample Start date is 1-1-2020 Due date is 100 Days from start date. Can you please guide how to find and with which formula. Eagerly waiting of your reply.

[@ramjipandey5182]

Sir ek aisa trick bataye jese 1 Jan likhey to month kitne dinka hai pata chalna chahiye

[@DeepakEduWorld]

+Ramji Pandey okay

[@thebaharcadetschool]

Sir tell about underage and overage formula in excel

[@payalkashyup4587]

Thanku so much sir 👍👍⛄ ⛄☺☺

[@DeepakEduWorld]

+Payal Kashyap 👍

[@gunindradas8042]

Sir datedif function not available in Excel 2010. Can I use other formula replace of it

[@pranjalinagpure1292]

Very helpful

[@bijaytanty8434]

Thanks Sir

[@ghurahuprasadyadav3798]

Fantastic tips sir

[@civilview6665]

Agar hame asha karna he 10 employer he.uski age likhi ho uska name chaiye jo sabse bada ho ummar me uska ak cell ne name fisplay chiye to kya formula hogi

[@Anuragrajpoot94]

Very nice video

[@stivenguzman3845]

Thank you

[@gd13523]

Nice video but I feel it lengthy, crisp video could have save time

[@sujit1920]

Nice learning 👍 Sir beyond 100 year me error show kr raha hai #value!

[@ManashBhatta]

Thank you sir. Need a help - age given 16 years 1 month 5 days on 15th March 1984. How to find date of birth in excel?

[@Abul_Rizvi]

Ek video Google form k upar banayea zarur

[@DeepakEduWorld]

+Abul Rizvi ok g

[@Abul_Rizvi]

Deepak EduWorld But plz be jaldi

[@albellaa]

Hello sir, kya AAP ye Bata sakte hai ki jaise mere paas "start_date" aur "din"(no.of days) hai aur ab mujhe inse end_date nikalani hai to use kaise nikalenge... Please tell me

[@itbpmasti6609]

Sir aap mujhe ye bataye ki hum jaise ki 25.05.19 to 30.05.19 date hai to kitna din hoga formula bataye.....