Date Functions & Formulas Part 2 | EDATE and EOMONTH Functions in Excel

[@Pyaritapasya36]

Innozant the best channel on TH-cam to learn Excel..♥️🧿 it's no. -1 , really thankful to you sir ..

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@lavkushsoni2968]

मैंने आपका वीडियो देखने के बाद इस वीडियो का कमेंट्स पढ़ा , कोई भी कमेंट नकारात्मक नहीं है और हो भी नहीं सकता क्योंकि आपके पढ़ने का स्टाइल ही ऐसा है ❤❤❤

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@kkrcreationstatus6583]

Dhanyabad Sir........Apki "Stamina" isi trah bani rahe aur hame kuchh naya sikhate rahe.

[@Innozant]

Thanks dear ..

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@Anujkumar20011]

Innozant channel is best for advanced excel

[@sandeepaswal8944]

प्रणाम सर जी | आज के वीडियो मैं मजा ही आ गया मुझे क्युकी नया सीखने को मिला | Date Functions & Formulas बहुत ही काम फंक्शन है |

[@Innozant]

Good

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@rosalinsetha6441]

Good morning sir, apka teaching is excellent👍

[@pramodcomputertips7872]

धन्यवाद सर जी, आपके बताये गए तरीके या फार्मूला से बड़ी से बड़ी समस्या से ऑफिस में निपटारा पाया हूं

[@Innozant]

Thanks Pramod Ji❤️❤️

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@pawanverma7220]

Ye Wo Function Hain Jo Institute Mai Koi Nahi Batata Hai,
But Interview mai aise hi Function puche jaate hain,
My Core Excel is getting Improve In because Of you Sir. 🙏🙏🙏

[@Innozant]

Thats Great..God Bless you..Happy learning Pawan

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@aqeelahmadengr3]

Very polite teaching style

[@Innozant]

Thanks ❤️

[@Azhar_Khan383]

great learning experience & awesome teaching style, Thansk Sir

[@Innozant]

Thanks Khan sahab..God bless You dear

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@xpertgaming5808]

thank you so much! i have learnt so much of excel in 2 months than I
could have tried to through courses

[@Innozant]

Thanks Dear...God bless you..have a wonderful career ahead ❤️❤️

[@inderdelhi]

Apko padhane me bhi khushi hoti hai, very nice

[@Innozant]

Yes dear..m enjoying my passion

[@inderdelhi]

@@Innozant Just now I Checked your website, you are very near from my Location, I am from Burari, I want to join you for Full MIS, Vba, sql, ms access.

[@shivshankarrajmane4170]

Sahi hai sir, I am preparing for mis analyst interview and I am watching your videos and feeling like khajana mil gaya

[@Innozant]

Haha.. Thanks Shivshankar Ji..Must watch complete Interview cracker and live interview series ..❤️🙏

[@minutyagi9110]

I also want to go in MIS but don't know how to enter pls guid me in better way I don't have any refrence and connections

[@mohansaini4912]

Power full Video....... 👍

[@yashsankhla2420]

sir aap bhot acche se samjhate hai aapki videos se main bhot kuch seekh chuka hu

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@mominacreations381]

Sir, your teaching style excellent ❤

[@Innozant]

Thanks dear.Keep growing

[@mominacreations381]

@@Innozant Sir in my life first time, i like and subscribe only your channel, May you live long and have a happy life.

[@Pooja-bd7zm]

लाजवाब 👌👌🤗🤗

[@Innozant]

Thanks Pooja ❤️❤️🙏

[@STAR-uh3jb]

Sir very smart experience and you very good learner teacher

[@Innozant]

Thanks dear ❤️

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@MohanKumar-uk1gj]

Sirji agar mera project 1-1-2021 se start hoga aur 8 months ka project hai mujhe Saturday aur Sunday ko exclude karke Jan na hai ke kis date pe mera project katam hoga kya edate function use hoga?

[@ManishVerma-gg8xl]

"अब ये क्या आफत है" आपके किसी भी टोपीक को समझाने का कोई तोड नही है आपके expression भी बहुत कुछ समझा जाते है बहुत मजा आता है आपकी class attend करके 🙂🙂🙂💗💗💗

[@Innozant]

Thanks Manish ji. Happy Diwali dear

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@royalrathore201]

Great work sir thankyou sir for giving us such a video 🎉

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@yudhisthirvaishnav3600]

Today formula bhi Cobain kr sakte hai

[@PriyaKumari-gk9xv]

Thank you sir ❤❤

[@cibiyadav9499]

You are great 👍 sir

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@PJ_05]

Thankyou so much sir 🥰

[@ravikamalabd]

Interesting and easy way approach to teach the subject Sir!

[@Innozant]

Thanks Ravi for your such a valuable feedback 🙏♥️

[@chetnakikan3721]

Very very good tutorial 👍👍👍Thnx sir

[@Innozant]

Thanks Chetna.
Happy Learning ❤️

[@meetmaheshwari617]

Liked , comment & subscribed🙏🙏

[@Innozant]

Thanks 🙏❤️

[@Rk-ik5lz]

Thank u sir my doubts clarified thank u so much.. Please do class on google sheet..

[@Innozant]

Google sheet play list are there

[@Rk-ik5lz]

@@Innozant oh ok i will check it sir, thank u..

[@Rk-ik5lz]

Sir one more doubt round, roundup, int, trunc exactly, what is the difference between them sir... I'm unable to explain in interview confusing sir, can u tell me pls sir....

[@sagarsinghrana1322]

Bhai good video hai aapki

[@virendersroha1754]

Great 👌 💥 sr

[@rahulshaw4648]

SIR , THANK YOU VERY MUCH ,YOU ARE DOING A GREAT WORK,..

[@Innozant]

Thanks Rahul ji..Happy learning

[@iamraza]

Thanks

[@mahantibangarinaidu103]

Excellent Sir

[@pawanwakale8801]

Sir in this Edate i took an example for date 13/6/2021 after entering the parameters Edate(13/6/21, 2) the output is 44421 ,why the output came like this when it was expected to go 2 months further 13/8/21

[@Innozant]

Oho..it is a date value dear..format issue.Your answer is right...just select that cell and convert it into date..you will get the expected result.

[@pawanwakale8801]

@@Innozant yeh now got the right answer by doing sort date

[@HarshYadav-py8hp]

​@@Innozantsir same issue araa hh paar jase aapne batayaa vase hogyaa solve paar baar baar uski setting change krne m tooh bohoot time waste hogaa iska solution kyaa h ki ek baar m hi hojaye?

[@cibiyadav9499]

Very nice teaching you sir thank you so much sir

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@shaktisinhgohil6599]

Thank you

[@Innozant]

Thanks 😊 🙏

[@rahulkashyap2704]

Amazing guru ji 🙏

[@Altaf_Alam]

Bahot mast sir..... Maja aagya......sir vba ka theory note down karna jaruri nahi na ?

[@Innozant]

Nhi..concept samjh aa jaye to koi issue nahi dear

[@Altaf_Alam]

@@Innozant ok sir thanks 🙏

[@warisafghan4211]

Thank you sir very helpful!
From where we can download that note you have explained in the background?🙏

[@golubro9517]

THANK YOUR SIR JIII😊

[@kirtisharma2373]

sir, why output of these two functions is different, while calculating no.of days....days360 and datedif....

[@Innozant]

Days360 works on 12 *30 days concept

[@kirtisharma2373]

@@Innozant thanks for the response..... looking forward for the detailed explanation.... 🙏🏻

[@roohulamin7519]

Learning style best

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@sadashivkage3133]

TQ...SIR...🙏🙏

[@arma2095]

Awesome VBA course teach sir

[@Innozant]

Thanks Arman sahab

[@vishalshelar697]

Amazing sir.. superb

[@Innozant]

Thanks Vishal ji❤❤🙏🙏

[@golubro9517]

Sir Aapki Yeh Line Wala Concept Accha Laga😅"Yeh Kya Afat Hai Mene Pass Kiya Umid Me Output Me Date Laane Kii Umid Kr Raha Tha Me😅

[@Innozant]

Hahahaha.. thanks ♥️

[@harisraw]

Helo sir ,
Ek question hai; agar koi adami 01-07-2000 ko enrol hota hai aur 17 saal ke baad retire ho jaata hai to uski retirement kaise nikalenge. Jaabki usi date of retirement 30 Jun hogi.
Kiya EIMONTH formula use ho sakta hai kiya ?????

[@rishikaramwala3498]

Nice explanation

[@Innozant]

Thanks ❤️

[@AfzalMohd-w8f]

Thank you sir

[@mamalibarisal4856]

Thank u so much sir

[@Sanddystar17]

beautiful concept sir😊🙏

[@Innozant]

Thanks Sandep🙏♥️🙂

[@battlefansshorts8941]

1 number sir ❤

[@Innozant]

Thanks you Ravi for your love and support ❤️👍🙏

[@anushreeshah9239]

Thank you so much Sir 🙏🏻

[@Innozant]

Thanks Anushree❤️❤️

[@MughalMahi-g6s]

44074 ye kisy solve kia ha home tabe m ja kr kis option m gy han kindly bta do

[@factad6582]

sir EOM me Random number aa hai

[@Unfiltered_ind]

Sir jo ye hai ... 44074 value hai ese mathmatical method se samjh dijye ki aata isse hai ... knowledge ke liye

[@wahidrashid4865]

Beautiful sir

[@Innozant]

Thanks Wahid sahab

[@alkagupta2401]

wonderful and helpful!

[@ramkishoryadav9087]

th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW

[@harivanshgautam3424]

Very nice video Sir. Beautifully explained the difference between edate and eomonth.🙏

[@Innozant]

Thanks Harivansh Jo for wonderful feedback always from you,Keep watching , Learn ,share and enhance your skills.

[@payaljain5497]

Too good...

[@Innozant]

Thanks Payal..We welcome you to experience the taste of Success with Innozant Seed of Success

[@muhammadsadiq2330]

Solved big problem of date value

[@anaditrivedi8539]

sir how to download assignments bcz i am unable to fetch it...

[@Innozant]

Kindly download assigment master folder from video description

[@deepakchauhan4974]

sir mere ko assignment dhundhne me problem hota hai, kaise dhundhu, google drive me redirect hone ke baad dhundhne pr milta nhi

[@deepakchauhan4974]

Please reply

[@Innozant]

already master assignment folder diya gaya hai Playlist wise..aap use download karen aur practice karen..video description me 2 link diye gye hain ek direct link aur dusra assignment master folder link

[@deepakchauhan4974]

@@Innozant let me check sir, or har chapter ka jaise jaise mai serial wise padh rha hu usme kaise pata chalega ki kaun kaha par hai

[@deepakchauhan4974]

@@Innozant nhi mila sir, advise me the link please ,

[@anilkumar-rr1qz]

Sir mera start date 26/01/2021,mujhe end date 25/02/2021 lana hai kaise hoga plz bataye

[@vijaysahal4556]

nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks

[@chandrashekharpandeya8115]

Agar kisi cheej ki expiry me date na di ho to EOMONTH FORMULA KESE LGAAYE?

[@rosalinsetha6441]

Plz sir Ai kya iske bareme thoda hum ko learn karein to sir bahut achha hoga

[@virendersroha1754]

Osm sr me use krta hu ye function

[@Innozant]

Good

[@sawaimalhi8439]

sir ye konsi book jis say aaap refer kr rhy hain ya aaap khud k bany hui notes hain

[@Innozant]

Koi books nahi refer karta hu main dear..mera custom creation hota hai

[@sawaimalhi8439]

@@Innozant kiya baat hai sir aaap ki

[@arslan6644]

If there are multiple translations in every day then How to highlight the last transaction of every day from a complete month/year?

[@mero2audio428]

Edate explain in year change sir ?

[@Innozant]

Didnt get your query?

[@nilanjanachoudhury8545]

thanks sir

[@Innozant]

Thanks Choudhary sahab❤❤

[@gauravbhatia7987]

Good sir

[@dishagupta6360]

Wow! You are so prompt Sir in answering questions. I want to learn all excel functions as well as how I can interrelate it in "HR". Pls help.

[@Innozant]

Thanks Disha for your valuable comment dear,Specially date & time function is important for HR person ,Kindly share your work details as what is your responsibilities there as HR,Will guide you Disha

[@RahulKumar93555]

Osm sir

[@harishtote9573]

Nice

[@Innozant]

Thanks Harish Ji,Recommend you to start watching videos from Basic excel step by step

[@praveenganje5004]

I failed to answer In my interview start date and same month end day..now I got answer how to calculate it's so simple after your video

[@Innozant]

Thanks Praveen Ji♥️👍

[@ashishsinghal6155]

sir formula kaise yad rakhe?

[@Innozant]

Practice krte krte khud mind chalne lgega

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@kunalsharma2661]

Sir eomonth se hum last ddate 30 per jaa skte h
But kisi kisi month m 31 days bhi hote h
Agr waha p jaana ho to ky krenge
Becoz maine har tarah se try kiya per last date pr jaakar +1 krta hu to vo 31 ki jagah agle month ki 1 per le jaata h

[@Innozant]

Kyu Kunal Ji..eomonth Function me jis bhi month Ka date paas krenge us month Ka akhiri date dikhayega wo chahe 30 Ka ho 31 Ka ho ya 28 Ka..phir us eomonth or bahar day paas kijiye kitne din Hain wo bta dega dear❤️❤️🙂

[@kunalsharma2661]

@@Innozant yes sir, Ab ho gya,
Sir lgta h aaj kuch jyada hi excel ki practice ho gyi thi
Jiski vajah se concentration kharab ho gya tha

[@Innozant]

Good Kunal❤️🙂

[@aadilfarooque8000]

Sir need ur no pls indirect formula ho nhe pata

[@PawanKumar-lc3du]

Sir ji, please help me, DOB if 1st day of the month then retirement date is previous month of the late day (i.e. DOB 01.05.1963 then retirement date is 30.04.2023)

[@Innozant]

Eomomth le saath paas kijiye required output ke liye

[@AnilBineeta1993]

👍👍

[@pawanverma7220]

I don't have laptop or desktop. Otherwise mai aapka paid course buy karta.
Mai jaha typing sikhta hu waha thoda time nikalkar practice karta hu aapki video dekhkar 🤭🤭🤭

[@Innozant]

Kahan rhete hain aap..?NCR ya kahin aur?

[@pawanverma7220]

@@Innozant Bulandshahr.
In future I will definitely join your classes 🙂🙂🙂

[@pawanverma7220]

@@Innozant The Way You Teach Is Awesome

[@nishankjain2562]

How to add date from 01/01/22 to 15/01/22 and 16/01/22 to 31/01/22 in same cell

[@sravi991]

Excel lllllllent !!!!!

[@Innozant]

Thanks dear

[@vijayshinde5954]

Month के जगह साल करना है तो कैसै करे।

[@dhakafady774]

wow

[@PawanKumar-lc3du]

Sir ji, Retirement date may =eomonth(BOD,12*60) hona chhiye, bcoz date of retirement is last date of month

[@Innozant]

Yes it depends..ydi aapko lasf date chaiye then eomonth jo aaone use kiya h that is fine but in case of same date you may use edate

[@PawanKumar-lc3du]

@@Innozant thanks sir ji

[@alkagupta2401]

Sir, How to use "EDATE" {EDATE(start_date, -1)} functionality in "Power Query in Excel"
Means to calculate the previous date where, month is previous month but date is same
e.g.
I/p is 2 dec 2012 ==> O/p is 2 Oct 2012
I/p is 9 Jan 2011 ==> O/p is 9 Dec 2010
I/p is 4 apr 2013 ==> O/p is 4 May 2013

[@KavitaKumari-ql2ru]

Sir 0

[@Innozant]

Kavita 0??
Kya query puchna chahtr hain?

[@rajibmukherjee9179]

Your way of explaining things are too good..thank you

[@optimisticsoul8064]

Sir mai date b select kr ra hu
EOMONTH(D50,0)
D50 = 15/08/2022
BUT ESME ANSWER #value! Esa ara hai

[@dhakafady774]

2162132

[@kuberanaik5967]

Thank you so much sir

[@preetivats4741]

❤❤❤❤

[@dhakafady774]

wow

[@dhakafady774]

wow

[@dhakafady774]

wow