Hello and welcome to our new video
In this video we are going to learn about two formulas
First is EDATE and second is EOMONTH
Now what do they do?
Let's go to excel
First of all I open excel and here I can see some data
First is name, second is date of birth and on third number
what will happen on 30th birthday
Retirement date and here two formulas EDATE and EOMONTH
Now what do these formulas do?
Now suppose my friend asked me that you were born in 1997
so tell me if I add 60 months then which year will it be?
Now if someone asks this then how will I deal with it?
Or if someone asks tell me what will be your retirement age?
What will be your retirement date?
I know retirement age is 60 but this 60 also varies
For example Supreme Court judges their retirement age is 65
High Court judges their retirement age is 62 and it can be
state wise also it varies like in Haryana retirement age is
60 so I have to find out when will be my 30th birthday and
which year will it be?
Now how will I know this?
We can calculate this there is no big problem
I also have formulas for this or I want to know my
retirement date
I also have formulas for that
So now what are the arguments that EDATE formula or EOMONTH
formula takes? Let's see what arguments take For example,
if I use EDATE then I will put sign of equals to and then I
will write EDATE
See it came here
Now it came here
Now it is showing argument first argument is start date and
second is month
So it deals in month
For example, if I want to know which year will be my 30th
birthday then I will write 5 year
If we do general calculation then what will be the result?
If you add 5 year in 1997 then what will be the result?
It will be 2002 and how many months are there in 5 years?
I have taken start date and then comma
I have to write month
How many months are there in 5 years?
We know that there are 60 months
So I wrote 60 and directly entered
So I got to know which year will be going on in my birthday
year 2002 I understood this
But we are doing deal in 30th birthday
Now 30th birthday means
I got to know that in 5 years there are 60 months
So I have to multiply 12 x 30
So 12 x 30
I wrote directly
Now how to write directly?
So instead of month
I wrote 12 and multiply 30 This is what we are doing
What to do in 5 years?
In 5 years
I have 12 months and I have to multiply 12 x 5
Same thing we are doing here 12 x 30
After this I have to enter and I will get 22nd April 2027
Means when my 30th birthday will be
Which year will be going on? 2027 Is it clear?
Now let's see the retirement date
It is same
But for that
Formula is EO month
So how to use EO month?
Before going to EO month
Let me tell you
In date format
But if you are doing for the first time or you have not
changed the format
Here we have seen in last videos
Excel doesn't know
In which format you want to do
So you have to tell
I am doing things in short date format
I am doing things in long date format
Otherwise it takes things
In general format
If I do it in general format
Then you will see a number here
This number will come
Because Excel doesn't know
You are doing things in date
So we have to tell it from here
If you are getting this kind of number
Then you have to change the format
Like short date or long date
You can also do short date
After this
Let's see
EO month formula
Same thing
Equals to sign
We have seen this many times
If you want to use any formula
Then you have to put Equals to sign
So here
EO month formula
Double click
Start date
Date of birth
You have selected
Same thing
Dealing in months
Now you know
When you retire
Normally you retire in 60
So for that I have to do 12x60 Then I will know
So many months
I have to put month number
For example
Here we do
Equals to
First Let's do this
After that I will show you
Selected here
As we have seen in previous
Multiply 12
For example for 5 years 5x60 But when number is big
Like here
I have to find 60 years
When I will be in retirement
How to find this
So for this
Directly 12x60
If your calculation is good
Then do 12x60
Where to write
Directly in month
So here I will do 12x60 So I got to know 57465 Again format
I told you
Here is general format
What you have to do
You have to change
So we changed it
In date format
And I got to know 30 April 2057
That year
When I will retire
So it will be clear
How to use both formulas
How to use E-date formula
How to use EO month formula
Now let's go to sheet number 2
Here also some data is written
Serial number, name, date of birth
Joining date
All of them are my friends
All of them
Here is their date of birth
Here is their joining date
So for some time
Some of them are High Court Judges
And some of them are Supreme Court Judges
So starting 5
Are Supreme Court Judges
And rest are
High Court Judges
So we know that age of Supreme Court and High Court Judges
Varies 65 and 62
To get retirement date
I have to use EO month formula
But 12 multiply
Here If I want to get
Rahul, Imran, Jishan, Shivam, Deepak
So what I have to do 12 multiply 65
But rest of them
Because they are High Court Judges
So what I have to do
Age of Retirement
Age of Retirement 12 multiply 62
So here
I write
EO month
No need to write
EO month
Double click
Start date
Joining date
Date of birth 65 years 62 years
Date of birth
Month 12 multiply 65 65 retirement age
Enter 30 April 2021 Retirement Retirement Drag Serial number
Retirement Retirement 65 years
Here I have to change 62 years
EO month
Double click
Start date
Date of birth
Month 12 multiply 62 Age of Retirement 62 Enter 30 April
Drag So I hope
You will be clear
How to use these two formulas
If you have any doubt
You have to play this video again
I will meet you
In next video
Till then practice