1

00:00:00,800 --> 00:00:07,660

Hello there this time we learn for form laws with respect to these simple formulas mostly used in data



2

00:00:07,680 --> 00:00:10,490

analysis along with logical statements.



3

00:00:10,490 --> 00:00:15,310

Now if you have already mentioned in one of the cells there's a formula which is called B.



4

00:00:15,560 --> 00:00:20,230

What it does it extracts the date that is turned 3.



5

00:00:20,240 --> 00:00:25,350

Now all the the formula Parminter says number but we are using a cell which contains a D.



6

00:00:25,460 --> 00:00:30,120

And if you remember from our earlier videos every valid date is a number.



7

00:00:30,260 --> 00:00:33,770

So I call the bracket and what I get is the form Larbi.



8

00:00:33,770 --> 00:00:40,130

Similarly if I write equal to m or n and press the tab key I'm going to choose the cell which contains



9

00:00:40,130 --> 00:00:46,650

the date close the bracket and what you get is a calendar month sequence for June which is 6.



10

00:00:46,670 --> 00:00:53,300

Now these formulas are generally used in combination with logical statements where you might see if



11

00:00:53,310 --> 00:01:00,570

the month is less than or equal to 6 which means January to June then perhaps take Step 1.



12

00:01:00,710 --> 00:01:03,520

If not then take Step 2.



13

00:01:03,770 --> 00:01:13,940

So in terms of formula Yode what we get now is as an NCO your 2011 now at times if you are getting a



14

00:01:14,000 --> 00:01:20,720

data in text format where the date month and year are separated by a certain value you may be getting



15

00:01:20,750 --> 00:01:24,290

those in different columns then export to Excel.



16

00:01:24,290 --> 00:01:31,040

How do you combine these components into one single cell which then is understood by Excel as the the



17

00:01:31,040 --> 00:01:34,060

formula to be written in is is beat.



18

00:01:34,160 --> 00:01:38,240

Let me write in the correct cell equal to be Eat Eat that dad.



19

00:01:38,660 --> 00:01:48,820

First it asks for your which I gladly choose comma then Mund comma and then followed by B.



20

00:01:48,890 --> 00:01:55,100

I choose the last Parliament I close the bracket I press and up and once I do that by default it shows



21

00:01:55,100 --> 00:01:59,010

me the read in the MDI format which is the default setting for this PC.



22

00:01:59,150 --> 00:02:06,260

If I then use this did I press control shift 3 it quickly changes it back to format that you not only



23

00:02:06,260 --> 00:02:09,420

show the deed but also the month in Jiyu in format.



24

00:02:09,620 --> 00:02:14,120

Those were for for the month and did form LA.