Namastai Sir ji.Wow I'm really so happy. Thanks a lots.sir ji. Bahut hi acha samjaya aapnai. DOB is 12/ 08/1994. aapnai August month bahut hi acha nikla. Thank u so much sir. God bless u. You are a great Teacher.
Hello sir i hope you are healthy and wealthy your video is awesome and not any problem to understand, sir in the end of the video there was a question you were asking, i solved this without any problem thanks sir for your precious and great hardwork, i hope you well be always teaching us.😇😇😇😇
Thanks a lot. Your way of simple teaching is really amazing. I watched the whole playlist of MIS. It was very very helpful. Thanks again!!!!!!!!!😇😇🙂😄😄💙💙💙
How do I create MM/DD/YYYY date format restrictions in Excel ? Means if anyone enter date other than this format then it should not accept and they should get prompt to enter date in MM/DD/YYYY format.
Hello sir I want to create conection between two device in excel, if i change in first device of excel sheet so it will auto update in second device. And Likewise it will happen with second device.
Thank you very much. I didn't even know this formula. I just come across your video and found out about the goldmine. What is the alternative to this formula from Excel because this one is from Lotus
Want to know exact months in two dates. Checked with datedif but it shows only month. I need to know exact months like 1.2 or 2.5 months etc. can you please help
Hi, Can you please help me out to resolve yhe date problem when we downloan data from SAP or ERP sometimes we not able use date as it's shows date but practically it is not in date format need to press F2 in each cell to convert i to date
Sir… Very interesting… Can u pls come up with a video on how to calculate employee retention rate, Attrition & turnover based on Hire date & Exit date.
It was an excellent function, I was searching this from long time , how to calculate, You resolved my query, you are great sir, I am completely dependent upon your videos for enhancing my skills, your videos helped me a lot , I am watching your videos serial wise and a great fan of yours, the way you describes things is great,. Sir my only problem is I get confused when I want to download practice file. Please show me the way how can search the topics of each related videos. Thanks sir
Sir, Your tutorials are mind blowing - yet so easily explained. I sincerely 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). My mobile app can do that.... but can excel tell me that? In that format? even 28.07.2024 will do. If yes - Please tell me - how? Thanks in advance.
Sir in interview there for Hr post but in test exam when I type formula to remove age so I m getting error today I try in my personal 💻 but I'm getting some msg(function datedif parameter 1 expects number values. but '24-01-1994' is a text and cannot be coerced to a number.) Plz let me know what problem 🙏🙏🙏
@@Innozant hmm thanku sir jee maine poora vidio nhi deka ta kl u tube k short me ye function koi lgana sika ra ta maine try kiya to huwa nhi isliye aapse pucha ta thanku so much problem ka solution btane k liye😊😊😊☺️😊
Sir datedif formula me start date, end date or phir unit lagane ke baad enter Karne par #value! show Kar Raha hai, iska kya reason ho Sakta hai. Please bataye.🙏
Galat kaga rhae ho Hativansh..Phirse date check kijiyt ..date format hi hai ya koi aur custom. Format..phirse krke dekhiye..stil isssue ..whatsapp me the screen shot..will solve it.
@@Innozant Sir date format Karne par or custom me change Karne ke baad bhi cell me date change nhi ho rhi thi but actual problem data option me jakar text to columns se step 3 me jakar date option unchecked tha. Wahan problem Mili.🙏
@@Innozant tu sir batyae agae k sath hum kise calculate krenge k itne minutes and second ho gye hai aaaj ki date k hisab say data birth ko compare kr k wo batye sir kise hoga formula likh k share krin please
Sir I have a question please respond soon Sir how can I find total sale of a person In given date Like 12/4/2012 11/5/2012 12/4/2013 How to find only sum of Apr month in both years Please respond soon 🙏
Hello Mr. Innozant Please Calculate Retirement date from DOB. How to Calculate retirement date ? and Pension Date and Pension Amounts Regards : M.Taufiq From Karachi Pakistan. 21-11-2023
Sir, i tried multiple times even checked the format..but always getting #value error. Sir kahan mistake ho rai hai samajh mein nai aa raha hai...i am using excel 365
Sir can you please make a formula to get m0 M1 M2 m3 M4 M5 as per month's instead of showing 2 years for the given date ,. It should only show M24 for 24 month's
सर ये फार्मूला सभी के लिए सही नही है क्यूकी इसमें दिन सही नही निकल सकते है जेसे कि मेरा जन्म दिन 17/02/1991 का है मेने आज ये विडियो देखा और अपनी ऐज चेक की इसमें साल और महीने तो सही आये लेकिन दिन गलत आये है
Namastai Sir ji.Wow I'm really so happy. Thanks a lots.sir ji. Bahut hi acha samjaya aapnai. DOB is 12/ 08/1994. aapnai August month bahut hi acha nikla. Thank u so much sir. God bless u. You are a great Teacher.
Mere prediction almost sahi tha 😄 apke bday ka.. Happy Belated birthday Sandeep
@@Innozant Haji Sir Ji. Sir thank you wishes on my birthday. aap hamesa uhi muskartai rahai.
Mai aapko dhodte hue hi comment section me aaya tha Sandeep ji🙏
Kal maine apply kiya ye Function. Aur Years, Month aur Day Ke saath concatenate kiya aur ho gaya.
Very Informative
very Good dear
Good morning sir ji 😊
Mai pura folder download kar rakha hu sir practice ke liye ❤️
👍❤️
sir you are true legend 🙏
Hello sir i hope you are healthy and wealthy your video is awesome and not any problem to understand, sir in the end of the video there was a question you were asking, i solved this without any problem thanks sir for your precious and great hardwork, i hope you well be always teaching us.😇😇😇😇
Good .Keep learning
Concept is very clear now n well explained..It's one of the mostly asked interview question topic👍
Yes ,Interview cracker ke practice kr lena aur mixed data number extraction part 2 bhi..use bilkul step by step dekhna aayega samajh.
Thanks a lot. Your way of simple teaching is really amazing. I watched the whole playlist of MIS. It was very very helpful. Thanks again!!!!!!!!!😇😇🙂😄😄💙💙💙
Thanks Harsha..Keep learning..step by step in sequence
Amazing Teaching skills...Thanks
Amazing guru ji ❤️
You are India's best Mentor😇😇
Thanks Amit . Happy learning..God blesd you
Logical master no 1 !
Thanks
Sir I have q ? Kya hum bina mouse KO use kiye scroll bar ko excel me keyboard se use Kat sakte hai kya?
Your videos are really very helpful. Thankyou Sir.
Thanks dear..Keep learning ❤️😊
Sir j formula kis version k excel per apply hote hain?
How do I create MM/DD/YYYY date format restrictions in Excel ? Means if anyone enter date other than this format then it should not accept and they should get prompt to enter date in MM/DD/YYYY format.
Thanks a lots sir You are amazing🙏🙏🙏🙏
Thanks Hemant ji
Thank u sir.n .Sry thoda dealay hogyi meri practice I missed ur some videos..
Koi nahi,Time jaise hi mile aapko sequence me pehle saare topic finish kijiye jahan tak video upload ho gye hain..tc
@@Innozant sure sir👍
Thanks a lot sir...👌👌👌🙏🙏🙏🙏
Well explained sir finally i understood
Thanks Sharmaji. Happy 🙂 learning .Have a wonderful career ahead
Thank You!!
Thanks ❤️❤️
Hello sir
I want to create conection between two device in excel, if i change in first device of excel sheet so it will auto update in second device. And
Likewise it will happen with second device.
Data connection between two workbook ?
Or device like..?
Thank you very much. I didn't even know this formula. I just come across your video and found out about the goldmine. What is the alternative to this formula from Excel because this one is from Lotus
Thanks dear.keep exploring 👍
@@Innozant Sir ji .. jab se aapka ye video dekha hai, bas I am binging on your video.. you have made them easy to follow .. thank you so much
Thanks a lot
Hi Sir, this is very good, here i have an query regarding numbers of days per months between two dates without header as Months
TQ...SIR....🙏
Want to know exact months in two dates. Checked with datedif but it shows only month. I need to know exact months like 1.2 or 2.5 months etc. can you please help
Hi,
Can you please help me out to resolve yhe date problem when we downloan data from SAP or ERP sometimes we not able use date as it's shows date but practically it is not in date format need to press F2 in each cell to convert i to date
There is no need to press F2 and then change the format,You may directly change the data type or its better to transform it using Power query
Nice information sir
Thanks Rahul❤️😊
Thanks a lot sir..u are amazing 👍
Thanks Suraj
Sir… Very interesting… Can u pls come up with a video on how to calculate employee retention rate, Attrition & turnover based on Hire date & Exit date.
Ok..Will make video for the same
I appreciate your help ☺️❤️
Thanks ❤️❤️
@@Innozant could you please write the formula to calculate hours, minutes, and seconds, I'm really confused 🥺
It was an excellent function, I was searching this from long time , how to calculate, You resolved my query, you are great sir, I am completely dependent upon your videos for enhancing my skills, your videos helped me a lot , I am watching your videos serial wise and a great fan of yours, the way you describes things is great,. Sir my only problem is I get confused when I want to download practice file. Please show me the way how can search the topics of each related videos. Thanks sir
Assignment are there in sequence Playlist wise ..download it and start your practice on regular basis.
Sir,
Your tutorials are mind blowing - yet so easily explained.
I sincerely 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).
My mobile app can do that.... but can excel tell me that?
In that format?
even 28.07.2024 will do.
If yes - Please tell me - how?
Thanks in advance.
Sir,
Please help.
❤❤❤
Thank you
Sir I have windows 8.1 and this function is not working. showing massage "value"
Sharma ji ..Now time tonupgrade office product 😊❤️
thank u sir 🙏🙏
Bade din se gayab hain aap karan Sahab...
@@Innozant ara nhi sir jaba bhi apa yaad Karo ga to apka samna a jaouga sir
When I click the download files , it redirects to I think around 15 files, but I dont know where is the particular things saved in that specific file.
drive.google.com/drive/mobile/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P/1ip6kBf6ATmuaZOUdC0LfaqTKxpwgEONi?usp=sharing&sort=13&direction=a
Sir in interview there for Hr post but in test exam when I type formula to remove age so I m getting error today I try in my personal 💻 but I'm getting some msg(function datedif parameter 1 expects number values. but '24-01-1994' is a text and cannot be coerced to a number.) Plz let me know what problem 🙏🙏🙏
Sir Your way of presentation is soon good.
Thanks Vunugopal ji..Happy Learning dear..God bless you❤️🙏
maza ah gya sir thank you so much
Thanks dear
Sir aapka video bahut hi helpful hota hai lekin aap excel ka pdf provide kara dete to samjhna aur bhi asan ho jata
Dear saare assignment diye gaye hain practice ke liye..video description me Jake link hai use aap download kar lein
love you ser
aapke smile bahut hi achcha hai
Thanks
Sir exsl 2013 me datedif function nhi h kya krun ab kripya btaiye ga
Excel won't recognise by excel but it works dear..batya hai. Maine already video me
@@Innozant hmm thanku sir jee maine poora vidio nhi deka ta kl u tube k short me ye function koi lgana sika ra ta maine try kiya to huwa nhi isliye aapse pucha ta thanku so much problem ka solution btane k liye😊😊😊☺️😊
Sir datedif formula me start date, end date or phir unit lagane ke baad enter Karne par #value! show Kar Raha hai, iska kya reason ho Sakta hai. Please bataye.🙏
Galat kaga rhae ho Hativansh..Phirse date check kijiyt ..date format hi hai ya koi aur custom. Format..phirse krke dekhiye..stil isssue ..whatsapp me the screen shot..will solve it.
@@Innozant Sir date format Karne par or custom me change Karne ke baad bhi cell me date change nhi ho rhi thi but actual problem data option me jakar text to columns se step 3 me jakar date option unchecked tha. Wahan problem Mili.🙏
Hello Sir, I have DOB so how can I calculate who all are turning age 65 in next month? Is there any way we can find out?
aapko pta krna h kya ki kitne months baad wo 65 ke ho jayenge
Sir, I need a help. If Second is given. SO how can I find out Hours, min, sec in 3 different cell.
Second only given ? Didnt get your query
@@Innozant suppose in cell A1 there is 3750 sec. I want B1 as 1 C1 2 and D1 as 30
🔥🔥🔥🔥🔥
Very nice sir
Thanks Bhoopi..tc
how to calculate birth year. if we don't know birth year??
Like ..what output you expect ?
Thanks sir
Thanks Ravi🙏❤️
Sir, what is confidence function 🤔🤔🤔
Hahahaha..when you are able to crack the interview ❤️
Nice sir
Thanks
Sir year month end day ek hi column m nikalo Bina concatenate k
Sir days formula nhi hai 2007 mein
Konsa excel chla rhe ho sir aap
Plz reply
Ashu Main ab to office 365 use krta hu pehle office 2013 aur 2016 me video bnaye hain
@@Innozant okk sir 2007 mein nhi hai ye function es liye nhi Mila
Par minus wale method se ho gya sir
Thanks for reply 🙏🙏
HOW TO CALCULATE COMING BIRTHDAY DATE WITH USING DATED IF FUNCTION , SIR
Sir iska Jo full formula hota hai jisme year month aur day ek hi formula me hota hai ispe video bana dijiye
sir ye jo mis cracker ke jo video aaye hai abhi tak uski ek sheet mil jati to maza aa jata
Already diye gye hain saare practice sheet dear..plese find link in description
bahot badiya hai sir par hours, mintues ,second wagera ka function aaap nay nhe krwaya kiya us ka use nhe hai zyda
haan hota hai thora bht ..Bana Dunga ek video time ke upar
@@Innozant tu sir batyae agae k sath hum kise calculate krenge k itne minutes and second ho gye hai aaaj ki date k hisab say data birth ko compare kr k wo batye sir kise hoga formula likh k share krin please
Good sir
♥️👍
Sir me ye formula use kar raha hu lekin kam nahi kar raha hai
Sir ye niche wale me "Yd"= 60 days nahi 59(30+28+1) days hone chahiye the very much confusion 🤔🤔
Kyuuuuuuu😀Pehl aap samjhao.phir door krta hu aapka confusion
Sir please bataye, ye problem raat ko sote vaqt disturb karega
=Datedif(Start date,end date,"y")&-Datedif(Start date,end date,"ym")&-Datedif(Start date,end date,"md")
Ye Wala formula lgao or age aik cell main pao
Sir but for my date of birth answer is coming wrong
Why Suraj.. check again
Sir please date function k aur videos upload kariye na
Already hai. Videos..aur bhi aayenge
Sir I have a question please respond soon
Sir how can I find total sale of a person
In given date
Like
12/4/2012
11/5/2012
12/4/2013
How to find only sum of Apr month in both years
Please respond soon 🙏
Hello Mr. Innozant
Please Calculate Retirement date from DOB.
How to Calculate retirement date ? and Pension Date and Pension Amounts
Regards : M.Taufiq From Karachi Pakistan. 21-11-2023
Sir its not working
Vivek ji alredy told you that this function not recogniclzed by excel but it works.jindlu check again..its working fine
Sir, i tried multiple times even checked the format..but always getting #value error. Sir kahan mistake ho rai hai samajh mein nai aa raha hai...i am using excel 365
Sir can you please make a formula to get m0 M1 M2 m3 M4 M5 as per month's instead of showing 2 years for the given date ,. It should only show M24 for 24 month's
Dear sir
please help
how to check month day by date
Example
15/1/2020 = 31
16/5/2020 = 31
4/6/2020 = 30
=day(eomonth (date,0))
@@Innozant
Thankyou sir.
It's working.
Mera bhi naam likhna sir...jab mera video ayega
Muje sikhado sir
सर ये फार्मूला सभी के लिए सही नही है क्यूकी इसमें दिन सही नही निकल सकते है जेसे कि मेरा जन्म दिन 17/02/1991 का है मेने आज ये विडियो देखा और अपनी ऐज चेक की इसमें साल और महीने तो सही आये लेकिन दिन गलत आये है
Kyu galat aayenge..current date se hi to apna dob count karoge aap
सर आज मे 32 साल 7 माह 22 दिन का हो गया हूँ और फार्मूला यूज़ करने पर 32 साल 7 महिना 7 दिन आ रहा है@@Innozant
जी सर मेने आज की डेट से ही काउंट किया है 08/10/2023 से@@Innozant
result showing this 29-12-2020 31-12-2020 =02-01-1900
Ato mera date of birth hai..😂
Sachme kya Moumita..
Happy Birthday in advance..Akne bday par yaad dila dena aap..main jaroor wiah krunga aapko.🙏❤️
🙄
❤❤🙏🙏
Sir Datedif Excel ka chori maal hai 🤣
Hahahaha
sir you are true legend 🙏
Thanks a lot
sir you are true legend 🙏
Thanks a lot
sir you are true legend 🙏
Thanks a lot
sir you are true legend 🙏
Thanks a lot
sir you are true legend 🙏
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot
Thanks a lot