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

Learn to use the EDATE and EOMONTH Functions with a simple example, explanation and downloadable Practice files.
1. Edate function in Excel
2.How to use Eomonth function in Excel
3. Edate and Eomonth Functions
4. Calculate retirement date with Edate and Eomonth functions
5.Calculate First day last month and first day next month
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Basic Excel-Date & Time Function-DateVideo2.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#edatefunction#eomonthfunction#Innozant #Excelformulaandfunction

[@tapasyajha7183]

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

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

[@sandeepaswal8944]

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

[@Innozant]

Good

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

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

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

[@IAMRAZA]

Thanks

[@pramodcomputertips7872]

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

[@Innozant]

Thanks Pramod Ji❤️❤️

[@ramkishoryadav9087]

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

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

[@aqeelahmadengr3]

Very polite teaching style

[@Innozant]

Thanks ❤️

[@cibiyadav9499]

Very nice teaching you sir thank you so much sir

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

[@PriyaKumari-gk9xv]

Thank you sir ❤❤

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

[@ManishVerma-gg8xl]

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

[@Innozant]

Thanks Manish ji. Happy Diwali dear

[@ramkishoryadav9087]

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

[@kuberanaik5967]

Thank you so much sir

[@mohansaini4912]

Power full Video....... 👍

[@cibiyadav9499]

You are great 👍 sir

[@ramkishoryadav9087]

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

[@roohulamin7519]

Learning style best

[@ramkishoryadav9087]

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

[@muhammadsadiq2330]

Solved big problem of date value

[@shaktisinhgohil6599]

Thank you

[@Innozant]

Thanks 😊 🙏

[@indermohan24]

Apko padhane me bhi khushi hoti hai, very nice

[@Innozant]

Yes dear..m enjoying my passion

[@indermohan24]

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

[@sagarsinghrana1322]

Bhai good video hai aapki

[@user-wp3zr7yp1l]

Thank you sir

[@mamalibarisal4856]

Thank u so much sir

[@golubro9517]

THANK YOUR SIR JIII😊

[@ravikamalabd]

Interesting and easy way approach to teach the subject Sir!

[@Innozant]

Thanks Ravi for your such a valuable feedback 🙏♥️

[@rahulshaw4648]

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

[@Innozant]

Thanks Rahul ji..Happy learning

[@meetmaheshwari617]

Liked , comment & subscribed🙏🙏

[@Innozant]

Thanks 🙏❤️

[@arma2095]

Awesome VBA course teach sir

[@Innozant]

Thanks Arman sahab

[@sadashivkage3133]

TQ...SIR...🙏🙏

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

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

[@rishikaramwala3498]

Nice explanation

[@Innozant]

Thanks ❤️

[@payaljain5497]

Too good...

[@Innozant]

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

[@wahidrashid4865]

Beautiful sir

[@Innozant]

Thanks Wahid sahab

[@rahulkashyap2704]

Amazing guru ji 🙏

[@chetnakikan3721]

Very very good tutorial 👍👍👍Thnx sir

[@Innozant]

Thanks Chetna.
Happy Learning ❤️

[@warisafghan4211]

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

[@mahantibangarinaidu103]

Excellent Sir

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

[@yudhisthirvaishnav3600]

Today formula bhi Cobain kr sakte hai

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

[@gauravbhatia7987]

Good sir

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

[@nilanjanachoudhury8545]

thanks sir

[@Innozant]

Thanks Choudhary sahab❤❤

[@RahulKumar93555]

Osm 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

[@Unfiltered_ind]

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

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

[@Pooja-bd7zm]

लाजवाब 👌👌🤗🤗

[@Innozant]

Thanks Pooja ❤️❤️🙏

[@virendersroha1754]

Great 👌 💥 sr

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

[@anushreeshah9239]

Thank you so much Sir 🙏🏻

[@Innozant]

Thanks Anushree❤️❤️

[@Sanddystar17]

beautiful concept sir😊🙏

[@Innozant]

Thanks Sandep🙏♥️🙂

[@chandrashekharpandeya8115]

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

[@vishalshelar697]

Amazing sir.. superb

[@Innozant]

Thanks Vishal ji❤❤🙏🙏

[@arslan6644]

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

[@alkagupta2401]

wonderful and helpful!

[@ramkishoryadav9087]

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

[@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♥️👍

[@anilkumar-rr1qz]

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

[@harishtote9573]

Nice

[@Innozant]

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

[@battlefansshorts8941]

1 number sir ❤

[@Innozant]

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

[@preetivats4741]

❤❤❤❤

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

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

[@factad6582]

sir EOM me Random number aa hai

[@virendersroha1754]

Osm sr me use krta hu ye function

[@Innozant]

Good

[@user-dk5ye3te4y]

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

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

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

[@sravi991]

Excel lllllllent !!!!!

[@Innozant]

Thanks dear

[@vijaysahal4556]

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

[@Innozant]

Thanks

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

[@dhakafady774]

wow

[@anaditrivedi8539]

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

[@Innozant]

Kindly download assigment master folder from video description

[@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❤️🙂

[@nishankjain2562]

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

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

[@AnilBineeta1993]

👍👍

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@mero2audio428]

Edate explain in year change sir ?

[@Innozant]

Didnt get your query?

[@ashishsinghal6155]

sir formula kaise yad rakhe?

[@Innozant]

Practice krte krte khud mind chalne lgega

[@vijayshinde5954]

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

[@aadilfarooque8000]

Sir need ur no pls indirect formula ho nhe pata

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

[@dhakafady774]

wow

[@PJ_05]

Thankyou so much sir 🥰

[@dhakafady774]

wow

[@dhakafady774]

wow