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 RUclips to learn Excel..♥️🧿 it's no. -1 , really thankful to you sir ..

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@lavkushsoni2968]

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

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@kkrcreationstatus6583]

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

[@Innozant]

Thanks dear ..

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.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

[@Azhar_Khan383]

great learning experience & awesome teaching style, Thansk Sir

[@Innozant]

Thanks Khan sahab..God bless You dear

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.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 ❤️❤️

[@mohansaini4912]

Power full Video....... 👍

[@aqeelahmadengr3]

Very polite teaching style

[@Innozant]

Thanks ❤️

[@sandeepaswal8944]

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

[@Innozant]

Good

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@IAMRAZA]

Thanks

[@PriyaKumari-gk9xv]

Thank you sir ❤❤

[@sagarsinghrana1322]

Bhai good video hai aapki

[@kuberanaik5967]

Thank you so much sir

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

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@STAR-uh3jb]

Sir very smart experience and you very good learner teacher

[@Innozant]

Thanks dear ❤️

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@shaktisinhgohil6599]

Thank you

[@Innozant]

Thanks 😊 🙏

[@cibiyadav9499]

Very nice teaching you sir thank you so much sir

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@pramodcomputertips7872]

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

[@Innozant]

Thanks Pramod Ji❤️❤️

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@cibiyadav9499]

You are great 👍 sir

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@muhammadsadiq2330]

Solved big problem of date value

[@yashsankhla2420]

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

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@roohulamin7519]

Learning style best

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@golubro9517]

THANK YOUR SIR JIII😊

[@user-wp3zr7yp1l]

Thank you sir

[@meetmaheshwari617]

Liked , comment & subscribed🙏🙏

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

[@sadashivkage3133]

TQ...SIR...🙏🙏

[@ManishVerma-gg8xl]

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

[@Innozant]

Thanks Manish ji. Happy Diwali dear

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@arma2095]

Awesome VBA course teach sir

[@Innozant]

Thanks Arman sahab

[@royalrathore201]

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

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@payaljain5497]

Too good...

[@Innozant]

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

[@rishikaramwala3498]

Nice explanation

[@Innozant]

Thanks ❤️

[@preetivats4741]

❤❤❤❤

[@PJ_05]

Thankyou so much sir 🥰

[@wahidrashid4865]

Beautiful sir

[@Innozant]

Thanks Wahid sahab

[@rahulshaw4648]

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

[@Innozant]

Thanks Rahul ji..Happy learning

[@yudhisthirvaishnav3600]

Today formula bhi Cobain kr sakte hai

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

[@rahulkashyap2704]

Amazing guru ji 🙏

[@gauravbhatia7987]

Good sir

[@RahulKumar93555]

Osm sir

[@mahantibangarinaidu103]

Excellent Sir

[@chetnakikan3721]

Very very good tutorial 👍👍👍Thnx sir

[@Innozant]

Thanks Chetna.
Happy Learning ❤️

[@ravikamalabd]

Interesting and easy way approach to teach the subject Sir!

[@Innozant]

Thanks Ravi for your such a valuable feedback 🙏♥️

[@Pooja-bd7zm]

लाजवाब 👌👌🤗🤗

[@Innozant]

Thanks Pooja ❤️❤️🙏

[@virendersroha1754]

Great 👌 💥 sr

[@vishalshelar697]

Amazing sir.. superb

[@Innozant]

Thanks Vishal ji❤❤🙏🙏

[@anushreeshah9239]

Thank you so much Sir 🙏🏻

[@Innozant]

Thanks Anushree❤️❤️

[@alkagupta2401]

wonderful and helpful!

[@ramkishoryadav9087]

ruclips.net/video/KtfoFOqM_0A/видео.htmlsi=OgYFAok7UptVEjxW

[@nilanjanachoudhury8545]

thanks sir

[@Innozant]

Thanks Choudhary sahab❤❤

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

[@battlefansshorts8941]

1 number sir ❤

[@Innozant]

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

[@Sanddystar17]

beautiful concept sir😊🙏

[@Innozant]

Thanks Sandep🙏♥️🙂

[@warisafghan4211]

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

[@Unfiltered_ind]

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

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

[@AnilBineeta1993]

👍👍

[@dhakafady774]

wow

[@virendersroha1754]

Osm sr me use krta hu ye function

[@Innozant]

Good

[@harishtote9573]

Nice

[@Innozant]

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

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

[@vijaysahal4556]

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

[@Innozant]

Thanks

[@factad6582]

sir EOM me Random number aa hai

[@sravi991]

Excel lllllllent !!!!!

[@Innozant]

Thanks dear

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

[@chandrashekharpandeya8115]

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

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

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

[@arslan6644]

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

[@anilkumar-rr1qz]

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

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

[@user-dk5ye3te4y]

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

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

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

[@mero2audio428]

Edate explain in year change sir ?

[@Innozant]

Didnt get your query?

[@nishankjain2562]

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

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

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

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

[@vijayshinde5954]

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

[@ashishsinghal6155]

sir formula kaise yad rakhe?

[@Innozant]

Practice krte krte khud mind chalne lgega

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

[@aadilfarooque8000]

Sir need ur no pls indirect formula ho nhe pata

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

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

[@mamalibarisal4856]

Thank u so much sir

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@dhakafady774]

wow

[@dhakafady774]

wow

[@dhakafady774]

wow