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

How To calculate difference between two dates in excel 2007 2010 2016 2013 in Hindi - Calculate Number Of Years, Number Months & Number of Days between two dates - Datedif() formula function in hindi -
How To Fix Excel Formula Errors #NAME? | #VALUE! | #REF! | #DIV/0! | ###### In Hindi
• How To Fix Excel Formu...
if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
___________________________________________________
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
𝗣𝗹𝗲𝗮𝘀𝗲 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 𝗠𝗲 𝗙𝗿𝗶𝗲𝗻𝗱𝘀 & 𝗦𝗵𝗼𝘄 𝗬𝗼𝘂𝗿 𝗟𝗼𝘃𝗲 𝗕𝘆 𝗟𝗶𝗸𝗲 𝗦𝗵𝗮𝗿𝗲 & 𝗖𝗼𝗺𝗺𝗲𝗻𝘁𝘀
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)
___________________________________________________
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld Playlist's:
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER TECHNICAL videos ► goo.gl/paZmpn
Automatic Invoice's in excel ► goo.gl/dFhg54
Subscribe to Deepak EduWorld ► / deepakeduworld
Follow on Instagram ► / deepak__nehra
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
Tags:
advence excel course,different between dates, date calculation in excel,formula error, advanced excel tutorial in hindi, deepak eduworld, deepak nehra, excel tips, excel user, computer user, technology, computer tips

Пікірлер: 387

  • @RajeshKumar-wh7gc
    @RajeshKumar-wh7gc5 жыл бұрын

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

  • @vishnusankpal6998
    @vishnusankpal69986 жыл бұрын

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

  • @lmyers0804
    @lmyers08043 жыл бұрын

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

  • @sahilsachdeva5303

    @sahilsachdeva5303

    3 жыл бұрын

    Speaking Hindi😍

  • @gospelverace
    @gospelverace2 жыл бұрын

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

  • @shyambhaskar4835
    @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

  • @rajeshshah6758
    @rajeshshah67584 жыл бұрын

    Great Sir creating something different from the regular.

  • @ashutoshsrivastava3877
    @ashutoshsrivastava38776 жыл бұрын

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

  • @DeepakEduWorld

    @DeepakEduWorld

    6 жыл бұрын

    thanks g

  • @bhatmushtak5912
    @bhatmushtak59125 ай бұрын

    You are really great,a true excel expert

  • @KPBHAIG
    @KPBHAIG2 жыл бұрын

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

  • @ITCE2018
    @ITCE20185 жыл бұрын

    So useful, very clear voice and explanation is good

  • @dakshkumar873
    @dakshkumar8732 жыл бұрын

    Tahnk you Sir. Aapne bahut acche se sikhaya.

  • @shreesantgulabraomaharaj2480
    @shreesantgulabraomaharaj24803 жыл бұрын

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

  • @LikeDislike83012
    @LikeDislike830123 жыл бұрын

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

  • @Kimyun-oq9qy
    @Kimyun-oq9qy Жыл бұрын

    Simple and super with detailed information

  • @ISMI786
    @ISMI7865 жыл бұрын

    Very informative, thanks.

  • @sujeetrajpoot2183
    @sujeetrajpoot21835 жыл бұрын

    thank you. its helpful in my job

  • @APNIMANJIL
    @APNIMANJIL5 жыл бұрын

    Very useful formula thanks so much.

  • @shabrotherss
    @shabrotherss11 ай бұрын

    Very very informative.... Thanks a TON

  • @Unseentrails
    @Unseentrails3 жыл бұрын

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

  • @debjyotighosh2414
    @debjyotighosh24146 жыл бұрын

    IT IS VERY HELPFUL...THANKS..

  • @pankajknowledgeworld
    @pankajknowledgeworld3 жыл бұрын

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

  • @puneetvij8433
    @puneetvij84336 жыл бұрын

    Excellent! ; )

  • @Jachaurasia27
    @Jachaurasia274 жыл бұрын

    Awesome technique really helpful

  • @gorakhanathk5054
    @gorakhanathk50544 жыл бұрын

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

  • @DeepakEduWorld

    @DeepakEduWorld

    4 жыл бұрын

    👍😊

  • @alokmandal6643
    @alokmandal66434 жыл бұрын

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

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki2 жыл бұрын

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

  • @jitendrabomble2218
    @jitendrabomble22182 жыл бұрын

    Thanks. Very useful information.

  • @IrfanKhan-lq9zz
    @IrfanKhan-lq9zz4 жыл бұрын

    Great sir Like always

  • @akramansari5317
    @akramansari5317 Жыл бұрын

    It's like you created new formula.

  • @rahultiwari9251
    @rahultiwari9251 Жыл бұрын

    Bahut badiya thanks sir

  • @RameshPal-cd4cs
    @RameshPal-cd4cs Жыл бұрын

    Very impressive and good.

  • @e_sgaming3598
    @e_sgaming35986 жыл бұрын

    Very good bro. Nice i watch yours videos

  • @zaibkhan6834
    @zaibkhan68346 жыл бұрын

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

  • @venkateshkademane2098

    @venkateshkademane2098

    3 жыл бұрын

    Great brother❤

  • @AnilKumar-co3mx
    @AnilKumar-co3mx3 жыл бұрын

    Bhut hi useful and save our time

  • @seetalkumar2831
    @seetalkumar28315 жыл бұрын

    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

    @technodex8678

    2 жыл бұрын

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

  • @KiranKumar123Go
    @KiranKumar123Go Жыл бұрын

    Thanks Brother 🙏

  • @nyeembashar1659
    @nyeembashar1659 Жыл бұрын

    Thank you. I was looking for this..

  • @MrPZAHOOR
    @MrPZAHOOR3 жыл бұрын

    Kamal ka formula Deepak Sir,

  • @electricus_aniruddhachanda8184
    @electricus_aniruddhachanda818411 ай бұрын

    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.

  • @devkum2733
    @devkum27336 жыл бұрын

    sir you give your best

  • @durgimajhi1629
    @durgimajhi16293 жыл бұрын

    Nic formula , sir.......

  • @venkateshkademane2098
    @venkateshkademane20983 жыл бұрын

    Great sir This was I was searching for yesterday

  • @jayjawanjaykisan7105
    @jayjawanjaykisan71054 жыл бұрын

    Very useful video . Thanks

  • @mdadivision4569
    @mdadivision45696 жыл бұрын

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

  • @nehajagdev2383
    @nehajagdev23833 жыл бұрын

    thanks very helpful video.

  • @burhanahmad5895
    @burhanahmad58956 жыл бұрын

    Very helpful.

  • @rajkumarsoni7683
    @rajkumarsoni768310 ай бұрын

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

  • @knowledgeabc0903
    @knowledgeabc09034 жыл бұрын

    Thank you, excellent

  • @abhishekpathak2751
    @abhishekpathak27515 жыл бұрын

    Very very helpful.......

  • @rahulmanoharan9746
    @rahulmanoharan97465 жыл бұрын

    Thanks Deepak. Good job

  • @DeepakEduWorld

    @DeepakEduWorld

    5 жыл бұрын

    😊

  • @Parimal_Asodiya
    @Parimal_Asodiya2 жыл бұрын

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

  • @Alish_Dodhia
    @Alish_Dodhia3 жыл бұрын

    Thnak u bro :)

  • @rjdr6014
    @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

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

  • @akakarun8
    @akakarun85 жыл бұрын

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

  • @mohitnamberdar2391
    @mohitnamberdar23914 жыл бұрын

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

  • @onlypattanaik8251
    @onlypattanaik82513 жыл бұрын

    Thanks a lot

  • @sarlakumbalpuri8779
    @sarlakumbalpuri87796 жыл бұрын

    Sir too good

  • @ajmalshahtravelling7088
    @ajmalshahtravelling70886 жыл бұрын

    good work

  • @ghurahuprasadyadav3798
    @ghurahuprasadyadav37985 жыл бұрын

    Fantastic tips sir

  • @paruljoshi3770
    @paruljoshi37706 жыл бұрын

    Very useful 👌👌👌

  • @gotamsindhi5277
    @gotamsindhi52776 жыл бұрын

    Excellent sir

  • @Digitalck
    @Digitalck6 жыл бұрын

    Very good trick sir ji.

  • @rameshwernagar1599
    @rameshwernagar15994 жыл бұрын

    शानदार bro

  • @someshwarbose
    @someshwarbose5 жыл бұрын

    Nice...thank you

  • @ssr6526
    @ssr6526 Жыл бұрын

    Yes badhiya hai ye formula

  • @neharatawal3604
    @neharatawal36046 жыл бұрын

    Sir apki voice superb..Videos awwwsmmmm..Sir m job krti hu..usme data se related work hota h..Data maintain se related sabhi videos dikhayiye sir..

  • @DeepakEduWorld

    @DeepakEduWorld

    6 жыл бұрын

    Please visit our channel playlist s... Of ADVANCED EXCEL TUTORIAL IN HINDI

  • @NavneetKumar-wf4pl
    @NavneetKumar-wf4pl11 ай бұрын

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

  • @bishtrajan969
    @bishtrajan9694 жыл бұрын

    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

  • @AJ.ZARRAR.GAMING
    @AJ.ZARRAR.GAMING8 ай бұрын

    Thanks sir

  • @mazharsiddiqui4567
    @mazharsiddiqui45676 жыл бұрын

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

  • @DeepakEduWorld

    @DeepakEduWorld

    6 жыл бұрын

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

  • @mahendrapatil2857
    @mahendrapatil28576 жыл бұрын

    i like it all videos about exel

  • @puravkansal7424
    @puravkansal74243 жыл бұрын

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

  • @khalil7337
    @khalil73373 жыл бұрын

    Super trick brother

  • @anusuyamahariya8980
    @anusuyamahariya89803 жыл бұрын

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

  • @yaspalsingh5028
    @yaspalsingh50286 жыл бұрын

    Very nice brother

  • @raazshortapptrick5736
    @raazshortapptrick57365 жыл бұрын

    good, and Thanks

  • @Pammirakeshsingh123
    @Pammirakeshsingh123 Жыл бұрын

    Thank sir

  • @gssspheelkhana941
    @gssspheelkhana9412 жыл бұрын

    very nice

  • @sumitnimbal7507
    @sumitnimbal75075 жыл бұрын

    Very nice so helpful

  • @DeepakEduWorld

    @DeepakEduWorld

    5 жыл бұрын

    🤗

  • @prashantkumar-op8jt
    @prashantkumar-op8jt3 жыл бұрын

    You are great Sir, Please meet me

  • @vijaypatel5269
    @vijaypatel52692 жыл бұрын

    Excellent

  • @rajkumarnirmalkar7906
    @rajkumarnirmalkar7906 Жыл бұрын

    Good 👍👍👍

  • @stivenguzman3845
    @stivenguzman38453 жыл бұрын

    Thank you

  • @payalkashyup4587
    @payalkashyup45876 жыл бұрын

    Thanku so much sir 👍👍⛄ ⛄☺☺

  • @DeepakEduWorld

    @DeepakEduWorld

    6 жыл бұрын

    +Payal Kashyap 👍

  • @arvindgirigauswami2196
    @arvindgirigauswami21966 жыл бұрын

    Well done sir

  • @DeepakEduWorld

    @DeepakEduWorld

    6 жыл бұрын

    thanks

  • @hashimsiddiqie8960
    @hashimsiddiqie89605 жыл бұрын

    Very nice

  • @vishalchandrani2962
    @vishalchandrani29626 жыл бұрын

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

  • @pranjalinagpure1292
    @pranjalinagpure12924 жыл бұрын

    Very helpful

  • @tarnaka504
    @tarnaka5046 жыл бұрын

    Nice.

  • @parwejcomputereducation9459
    @parwejcomputereducation94596 жыл бұрын

    Superb sir

  • @mallikarjunabagali9001
    @mallikarjunabagali90013 жыл бұрын

    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

  • @marutishinde309
    @marutishinde309 Жыл бұрын

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

  • @Anuragrajpoot94
    @Anuragrajpoot943 жыл бұрын

    Very nice video

  • @arunkumarkumbhar2806
    @arunkumarkumbhar2806 Жыл бұрын

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

  • @vinaykaushik8831
    @vinaykaushik8831 Жыл бұрын

    Thanks!

  • @ManashBhatta
    @ManashBhatta5 жыл бұрын

    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?

  • @krishnavenimitta574
    @krishnavenimitta5744 жыл бұрын

    Thank you sir

  • @dhansayyadav7085
    @dhansayyadav70855 жыл бұрын

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

  • @DeepakEduWorld

    @DeepakEduWorld

    5 жыл бұрын

    Okay g.. I will publish video shortly

  • @dhansayyadav7085

    @dhansayyadav7085

    5 жыл бұрын

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

  • @kirandeepchoudhry9232

    @kirandeepchoudhry9232

    5 жыл бұрын

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

  • @kirandeepchoudhry9232

    @kirandeepchoudhry9232

    5 жыл бұрын

    Shayad ho jaye

  • @bhaskarmukherjee7889
    @bhaskarmukherjee78892 жыл бұрын

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

  • @yuvrajb4696
    @yuvrajb46962 жыл бұрын

    Jay ho Jay Hind

Келесі