Date Functions & Formulas Part 2 | EDATE and EOMONTH Functions in Excel
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- 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
Innozant the best channel on TH-cam to learn Excel..♥️🧿 it's no. -1 , really thankful to you sir ..
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
मैंने आपका वीडियो देखने के बाद इस वीडियो का कमेंट्स पढ़ा , कोई भी कमेंट नकारात्मक नहीं है और हो भी नहीं सकता क्योंकि आपके पढ़ने का स्टाइल ही ऐसा है ❤❤❤
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Dhanyabad Sir........Apki "Stamina" isi trah bani rahe aur hame kuchh naya sikhate rahe.
Thanks dear ..
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Sahi hai sir, I am preparing for mis analyst interview and I am watching your videos and feeling like khajana mil gaya
Haha.. Thanks Shivshankar Ji..Must watch complete Interview cracker and live interview series ..❤️🙏
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
प्रणाम सर जी | आज के वीडियो मैं मजा ही आ गया मुझे क्युकी नया सीखने को मिला | Date Functions & Formulas बहुत ही काम फंक्शन है |
Good
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
thank you so much! i have learnt so much of excel in 2 months than I
could have tried to through courses
Thanks Dear...God bless you..have a wonderful career ahead ❤️❤️
great learning experience & awesome teaching style, Thansk Sir
Thanks Khan sahab..God bless You dear
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
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. 🙏🙏🙏
Thats Great..God Bless you..Happy learning Pawan
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Thanks
धन्यवाद सर जी, आपके बताये गए तरीके या फार्मूला से बड़ी से बड़ी समस्या से ऑफिस में निपटारा पाया हूं
Thanks Pramod Ji❤️❤️
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
sir aap bhot acche se samjhate hai aapki videos se main bhot kuch seekh chuka hu
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Very polite teaching style
Thanks ❤️
Very nice teaching you sir thank you so much sir
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Great work sir thankyou sir for giving us such a video 🎉
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Thank you sir ❤❤
Sir very smart experience and you very good learner teacher
Thanks dear ❤️
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
"अब ये क्या आफत है" आपके किसी भी टोपीक को समझाने का कोई तोड नही है आपके expression भी बहुत कुछ समझा जाते है बहुत मजा आता है आपकी class attend करके 🙂🙂🙂💗💗💗
Thanks Manish ji. Happy Diwali dear
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Thank you so much sir
Power full Video....... 👍
You are great 👍 sir
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Learning style best
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
Solved big problem of date value
Thank you
Thanks 😊 🙏
Apko padhane me bhi khushi hoti hai, very nice
Yes dear..m enjoying my passion
@@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.
Bhai good video hai aapki
Thank you sir
Thank u so much sir
THANK YOUR SIR JIII😊
Interesting and easy way approach to teach the subject Sir!
Thanks Ravi for your such a valuable feedback 🙏♥️
SIR , THANK YOU VERY MUCH ,YOU ARE DOING A GREAT WORK,..
Thanks Rahul ji..Happy learning
Liked , comment & subscribed🙏🙏
Thanks 🙏❤️
Awesome VBA course teach sir
Thanks Arman sahab
TQ...SIR...🙏🙏
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😅
Hahahaha.. thanks ♥️
Bahot mast sir..... Maja aagya......sir vba ka theory note down karna jaruri nahi na ?
Nhi..concept samjh aa jaye to koi issue nahi dear
@@Innozant ok sir thanks 🙏
Nice explanation
Thanks ❤️
Too good...
Thanks Payal..We welcome you to experience the taste of Success with Innozant Seed of Success
Beautiful sir
Thanks Wahid sahab
Amazing guru ji 🙏
Very very good tutorial 👍👍👍Thnx sir
Thanks Chetna.
Happy Learning ❤️
Thank you sir very helpful!
From where we can download that note you have explained in the background?🙏
Excellent Sir
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 ?????
Today formula bhi Cobain kr sakte hai
Thank u sir my doubts clarified thank u so much.. Please do class on google sheet..
Google sheet play list are there
@@Innozant oh ok i will check it sir, thank u..
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....
Good sir
Very nice video Sir. Beautifully explained the difference between edate and eomonth.🙏
Thanks Harivansh Jo for wonderful feedback always from you,Keep watching , Learn ,share and enhance your skills.
thanks sir
Thanks Choudhary sahab❤❤
Osm sir
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.
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
Sir jo ye hai ... 44074 value hai ese mathmatical method se samjh dijye ki aata isse hai ... knowledge ke liye
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?
लाजवाब 👌👌🤗🤗
Thanks Pooja ❤️❤️🙏
Great 👌 💥 sr
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
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.
@@Innozant yeh now got the right answer by doing sort date
@@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?
Thank you so much Sir 🙏🏻
Thanks Anushree❤️❤️
beautiful concept sir😊🙏
Thanks Sandep🙏♥️🙂
Agar kisi cheej ki expiry me date na di ho to EOMONTH FORMULA KESE LGAAYE?
Amazing sir.. superb
Thanks Vishal ji❤❤🙏🙏
If there are multiple translations in every day then How to highlight the last transaction of every day from a complete month/year?
wonderful and helpful!
th-cam.com/video/KtfoFOqM_0A/w-d-xo.htmlsi=OgYFAok7UptVEjxW
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
Thanks Praveen Ji♥️👍
Sir mera start date 26/01/2021,mujhe end date 25/02/2021 lana hai kaise hoga plz bataye
Nice
Thanks Harish Ji,Recommend you to start watching videos from Basic excel step by step
1 number sir ❤
Thanks you Ravi for your love and support ❤️👍🙏
❤❤❤❤
sir, why output of these two functions is different, while calculating no.of days....days360 and datedif....
Days360 works on 12 *30 days concept
@@Innozant thanks for the response..... looking forward for the detailed explanation.... 🙏🏻
sir mere ko assignment dhundhne me problem hota hai, kaise dhundhu, google drive me redirect hone ke baad dhundhne pr milta nhi
Please reply
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
@@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
@@Innozant nhi mila sir, advise me the link please ,
sir EOM me Random number aa hai
Osm sr me use krta hu ye function
Good
44074 ye kisy solve kia ha home tabe m ja kr kis option m gy han kindly bta do
sir ye konsi book jis say aaap refer kr rhy hain ya aaap khud k bany hui notes hain
Koi books nahi refer karta hu main dear..mera custom creation hota hai
@@Innozant kiya baat hai sir aaap ki
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 🤭🤭🤭
Kahan rhete hain aap..?NCR ya kahin aur?
@@Innozant Bulandshahr.
In future I will definitely join your classes 🙂🙂🙂
@@Innozant The Way You Teach Is Awesome
Excel lllllllent !!!!!
Thanks dear
nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻
Thanks
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)
Eomomth le saath paas kijiye required output ke liye
wow
sir how to download assignments bcz i am unable to fetch it...
Kindly download assigment master folder from video description
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
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❤️❤️🙂
@@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
Good Kunal❤️🙂
How to add date from 01/01/22 to 15/01/22 and 16/01/22 to 31/01/22 in same cell
Sir ji, Retirement date may =eomonth(BOD,12*60) hona chhiye, bcoz date of retirement is last date of month
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
@@Innozant thanks sir ji
👍👍
❤️❤️❤️❤️
Edate explain in year change sir ?
Didnt get your query?
sir formula kaise yad rakhe?
Practice krte krte khud mind chalne lgega
Month के जगह साल करना है तो कैसै करे।
Sir need ur no pls indirect formula ho nhe pata
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
Sir 0
Kavita 0??
Kya query puchna chahtr hain?
Your way of explaining things are too good..thank you
Sir mai date b select kr ra hu
EOMONTH(D50,0)
D50 = 15/08/2022
BUT ESME ANSWER #value! Esa ara hai
2162132
wow
Thankyou so much sir 🥰
wow
wow