Hello and welcome to our new video.
In this video, we are going to learn about tax formula.
Tax formula is a very important formula.
Many times we are asked like in competitive exams, a
particular date is given like 25th January 2090.
And we are asked to tell the date.
How will you tell?
It becomes a little difficult.
So tax formula helps us.
Now what does tax formula do?
It changes the formatting.
If you want to change the format of anything, then you can
change it with tax formula.
And the particular thing which is written in a particular
format, you can also extract it.
If you are not able to understand this, then let's open the
excel sheet and see how to use all the things I am saying.
First of all, I open the excel sheet.
And I have two sheets here.
In sheet 1, some data is written.
And in sheet 2, some data is also there.
Let's see sheet 1 data.
Some dates are written here.
Like 21st March 22nd April 23rd May 24th June 25th December
And here is the date, month, year and day.
First of all, understand what does formatting mean? 21st
March 2023 is written in a particular format.
If I write here 21st and oblique
March 2023 If you see this, it is written in a different
format.
One second, it is correct.
21st March 2023 If you see this, it is correct.
How to make a column in a date?
Date has four or five dates.
But there could be 700 or 800 unique lists.
And it is not even a formula.
You can't make a column in any given date.
You can't make the dates user to self.
You need to excecute the date in the format.
You need to excute the date in the format.
Extract
Here we have to use Text Formula
We have to put Equals to
Then we have to write
Text Now we have to double click
First it will ask value
We have selected value
After that it will ask
Format Text
Tell me what kind of format you want
Like we want to get 21 Here one more thing is happening
Double click
All other cells will be filled with date
It will be extracted
Same thing I have to do
Suppose someone said
I have to prepare month column
Now month column will also be prepared with
Text Formula
Same thing you have to do
Equals to
Double click
First it will ask
Value After that
Format Text
Double click
What I have to get
I have to get month
I have to write
MM Double click
Close bracket
I have got 03 This is month
If I have to get last
Double click
Drag I have to get
Drag I have got
Month Third Fourth Fifth Sixth Twelfth Same thing
We have to get
Year It is asking us
Value We have to get
Year Comma Format Text
You have to get
Year in two ways
If I write
Y in double quote
What is the answer
If I write
Y in double quote
What is the answer
Drag I have got
All years 26, 38, 22, 90
I have got
Last two digits
I have not got four digits
What I have to do
I have to write
Y in double quote
After that
Enter Drag You can ask
DD I have written
DD AMP DS DD DD DD DD DD DD Now I have to find out what day
is it on 21st March, 2023.
Today I can tell you what day it is.
Today when I am recording, I know it is Tuesday.
But if someone tells me what day it is on 25th December,
2090, then I will get a headache.
Then I will sit with a calendar and see the whole thing in
2090.
And then after wasting 3-4 minutes, 5 minutes,
I will tell you what day it is.
So it is better to use the text formula in Excel.
You can find it easily.
So what I have to do here is,
I have to put equals to here, and I will write text.
It has suggested me.
I double clicked on it.
And it is asking me to tell the value.
So what will we put in the value?
This is what we put in the value.
After this, I put a comma here, and then asked format text.
Now what you have to do with the format text, you have to
write ddd three times.
What will come if you write ddd three times?
Let's enter it.
As it has come,
TUE Tuesday has come.
Now let's drag it down.
So what happened?
Wednesday, Sunday, Friday, Monday.
But if you say that I want a proper name like this, it
should be fully written, it should be written on Sunday, it
should be written on Wednesday, or it should be written on
Saturday, then what will we do?
So you don't have to do much.
Instead of writing ddd three times, write ddd four times.
Okay.
And then enter it simply.
Look, it's all written.
Now what do you have to do down?
You have to drag it like this.
So Tuesday, Wednesday, Sunday, Friday, Monday, it is
written.
So, have you understood what the text formula is saying?
The text formula is a particular format.
It helps us extract the format.
If I want a date,
I took out the date and gave it.
If I want a month,
I took out the month and gave it.
If I want a year,
I took out the year and gave it.
So it helps us in this way.
And even a particular date,
I feel very good that you have been given a particular
date, 2090, 2098.
Now, you can find out which day this particular date is.
After this, let's go to sheet number 2 and see how the text
formula will be used there.
If I tell you that whatever is written here, you have to
add 20 or 30 in front of it.
Will you be able to do it?
Let's do it and see.
I write here 102030.
Okay, and then I enter it.
It didn't happen.
We saw this in the last video that this format, which
format is this?
This is the number format or general format.
but we can never put 0 in number format we put it in text
format we have seen this before so because we have text
formula so we can use text formula to change its formatting
and we can put 0 in front of it now how to do this so you
have to do simple you have to put a question you have to
write text and after writing text what is the value so what
I will do
I will choose this after that here it is telling me to tell
the text format so I said let's tell the format so I wrote
here in double quote 1,2,3,4,5,6 whatever 0 you want now
what does it mean total is 6 digits out of 6 digits last 3
digits will be 7500 remaining 3 digits will be 0 so I write
double quote close the bracket and enter now see it is
written 650 so if I apply it on all so what will happen it
is 80,000 so what will be in front of 80,000 it will be 0
so what we have to do we have to
click and see its format changed so whatever is written
8,7,9 let's make it bigger
now see we have not applied anything we have not applied
text format so if we put 0 in front of it see 8,7,9 so we
know that with the help of text we can put 0 so I hope you
liked this video whatever we have done with the help of
text you must have understood if you still have any doubt
then watch this video again
I will meet you in the next video till then keep practicing