Hello there this time we learn for form laws with respect to these simple formulas mostly used in data
analysis along with logical statements.
Now if you have already mentioned in one of the cells there's a formula which is called B.
What it does it extracts the date that is turned 3.
Now all the the formula Parminter says number but we are using a cell which contains a D.
And if you remember from our earlier videos every valid date is a number.
So I call the bracket and what I get is the form Larbi.
Similarly if I write equal to m or n and press the tab key I'm going to choose the cell which contains
the date close the bracket and what you get is a calendar month sequence for June which is 6.
Now these formulas are generally used in combination with logical statements where you might see if
the month is less than or equal to 6 which means January to June then perhaps take Step 1.
If not then take Step 2.
So in terms of formula Yode what we get now is as an NCO your 2011 now at times if you are getting a
data in text format where the date month and year are separated by a certain value you may be getting
those in different columns then export to Excel.
How do you combine these components into one single cell which then is understood by Excel as the the
formula to be written in is is beat.
Let me write in the correct cell equal to be Eat Eat that dad.
First it asks for your which I gladly choose comma then Mund comma and then followed by B.
I choose the last Parliament I close the bracket I press and up and once I do that by default it shows
me the read in the MDI format which is the default setting for this PC.
If I then use this did I press control shift 3 it quickly changes it back to format that you not only
show the deed but also the month in Jiyu in format.
Those were for for the month and did form LA.