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
Sir aap ka excel shikhane ka tarika aalag hi hai thinks for addvions knowledge ke liye
Thank you sir , it is very useful formula and also you have saved us one app memory.
So easy to understand that I did not even know the language he is speaking. Top-notch demonstration!! I subscribed.
@sahilsachdeva5303
3 жыл бұрын
Speaking Hindi😍
Abhi Maine aapne jaisa sikhaya, kiya aur ho gaya. Aur tareeka bhi malum ho gaya. Dil se dhanyawaad.
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
Great Sir creating something different from the regular.
sir aap to bhut ache master ho aap se Acha master to koi h hi nhi sir waooo very nice knowledge video....
@DeepakEduWorld
6 жыл бұрын
thanks g
You are really great,a true excel expert
बहुत बढ़िया वीडियो, सबसे सरल, सबसे आसान।। धन्यवाद शुक्रिया
So useful, very clear voice and explanation is good
Tahnk you Sir. Aapne bahut acche se sikhaya.
मैं भी शुरूमे उसको डेटेड इफ ही बोलता था लेकिन मुझे लगता हैं कि वो डेट डिफ हैं। आपके एक्सेल के वीडियोस मुझे सबसे ज्यादा पसंद आते हैं। कुछ जगह स्पेलिंग मिस्टेक होती हैं। मुझे कोई फरक नही पड़ता। मुझे केवल एक्सेल सीखने से मतलब हैं। कुछ लोग बोल सकते हैं।
Thanks Sir yeh Experience Kay liye kaam aa Gaya Experience aur Date birth Kay liye
Simple and super with detailed information
Very informative, thanks.
thank you. its helpful in my job
Very useful formula thanks so much.
Very very informative.... Thanks a TON
Thanks bro aapne mere 3din ke work ko 3min me krwa diya aur kuch naya sikha bhi diya
IT IS VERY HELPFUL...THANKS..
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 आती
Excellent! ; )
Awesome technique really helpful
Fantastic. "datedif()" formula is not in excel library, still it works!!!. AMAZING! That means wwe can define our library also?
@DeepakEduWorld
4 жыл бұрын
👍😊
Liked the vedio...too much...thankyou
Very nice sir I am expert I after see this video okay bye
Thanks. Very useful information.
Great sir Like always
It's like you created new formula.
Bahut badiya thanks sir
Very impressive and good.
Very good bro. Nice i watch yours videos
Sir very informative video I like it very helpful for me thank you sir sooo much from Pakistan at Karachi
@venkateshkademane2098
3 жыл бұрын
Great brother❤
Bhut hi useful and save our time
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
2 жыл бұрын
same the formula dont exits do we need to set it manually any help
Thanks Brother 🙏
Thank you. I was looking for this..
Kamal ka formula Deepak Sir,
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.
sir you give your best
Nic formula , sir.......
Great sir This was I was searching for yesterday
Very useful video . Thanks
Sir, you are doing excellent job. pl. give the download link also
thanks very helpful video.
Very helpful.
Thanks mujhe yah bahut din de dundhne par mila but जिसे aapne hide किया उस कालम के बिना ही क्या years, month, day ka chart banaya ja sakta hai.
Thank you, excellent
Very very helpful.......
Thanks Deepak. Good job
@DeepakEduWorld
5 жыл бұрын
😊
અદ્ભુત , તમારો ખુબ ખુબ આભાર , સાહેબ
Thnak u bro :)
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.
Excellent. Is there any way to get only business days (5 Days Mon-Fri) instead the calendar days?
Very very.........nice yur.....vidio
Thanks a lot
Sir too good
good work
Fantastic tips sir
Very useful 👌👌👌
Excellent sir
Very good trick sir ji.
शानदार bro
Nice...thank you
Yes badhiya hai ye formula
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
6 жыл бұрын
Please visit our channel playlist s... Of ADVANCED EXCEL TUTORIAL IN HINDI
SO Wandrful FULL ♥️♥️♥️♥️♥️♥️
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
Thanks sir
दोस्त आपके समझाने का तरीका अच्छा यदि में गलत नहीं हूं आप साइंस साइड के स्टूडेंट् हो मैं आपकी सभी वीडियो देखता हूं समझाते ऐसा हो कि वीडियो दोबारा देखना नही पड़ता एक बार मैं माइंड में फिट सेट हो जाता हैं
@DeepakEduWorld
6 жыл бұрын
+Mazhar Siddiqui MASTER IN TECHNOLOGY... M. Tech...
i like it all videos about exel
Great work...plz improve video quality. Screen is not visible clearly. Thanks
Super trick brother
Nice.. Very helpful Sir yadi en date m se RBI Holidays minus karne ho (each Sunday and second Saturday) to kaise kare
Very nice brother
good, and Thanks
Thank sir
very nice
Very nice so helpful
@DeepakEduWorld
5 жыл бұрын
🤗
You are great Sir, Please meet me
Excellent
Good 👍👍👍
Thank you
Thanku so much sir 👍👍⛄ ⛄☺☺
@DeepakEduWorld
6 жыл бұрын
+Payal Kashyap 👍
Well done sir
@DeepakEduWorld
6 жыл бұрын
thanks
Very nice
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 ...
Very helpful
Nice.
Superb sir
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
Hello Sir मुझे महिने के हिसाब से दिन निकलने hai जैसे की अगर हम किसी month का नाम डाल दे तो उसके पुरे दीन कितने है वो निकलना चाहीहे कैसे करें
Very nice video
Will be obliged to know the formula calculating week - day difference between two date's.Thanks
Thanks!
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?
Thank you sir
दो तिथियों के अन्तर को आपने बड़े अच्छे ढंग से समझाया , धन्यवाद , किन्तु एक समस्या को कैसे हल किया जायगा ------ आपने वर्ष को वर्ष से , माह को माह से , तथा दिन को दिन से घटाया पर यदि जिस दिनांक को घटा रहे है उसका दिन व ,माह बड़ा हो तो कैसे घटाएंगे जैसे ---- 09 /10/1999 में से 26 / 11/ 2015 यहाँ दिन माह वर्ष के क्रम में दिनांक लिखा गया है.
@DeepakEduWorld
5 жыл бұрын
Okay g.. I will publish video shortly
@dhansayyadav7085
5 жыл бұрын
आपने हमारी समस्या को संज्ञान में लिया आपका बहुत बहुत धन्यवाद , अब बस इन्तजार है .
@kirandeepchoudhry9232
5 жыл бұрын
Sir, apne computer keyboard date format ko badal de text to column se
@kirandeepchoudhry9232
5 жыл бұрын
Shayad ho jaye
Hi Sir, is there any way in Excel to write number into words.
Jay ho Jay Hind