1

00:00:00,810 --> 00:00:07,440

Hello everybody in this video session I talk about the concept of Beat the way they're stored in a cell



2

00:00:07,500 --> 00:00:09,260

and why should you know this.



3

00:00:09,270 --> 00:00:14,940

Well if you happen to work with the formulas or if you happen to clean it up when the dates are in the



4

00:00:14,940 --> 00:00:18,050

wrong format you must know this prerequisite.



5

00:00:18,210 --> 00:00:20,230

We exist towards the deed.



6

00:00:20,430 --> 00:00:25,300

If you don't then you will not be able to perform do the deed or cleaning exercises successfully.



7

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

And at times you'll find difficulty in writing if a with respect to leaks.



8

00:00:30,480 --> 00:00:32,590

So let's see what lies ahead.



9

00:00:32,910 --> 00:00:38,070

Well to start with every valid bid in Excel is a number.



10

00:00:38,400 --> 00:00:39,560

And what is that number.



11

00:00:39,690 --> 00:00:45,210

It's the number that says the number of days of it from the start of the now it might sound like a jargon.



12

00:00:45,210 --> 00:00:47,430

Let me explain through this diagram.



13

00:00:47,450 --> 00:00:52,690

Let's assume on our timeline there's a date called 34 December 1899.



14

00:00:52,710 --> 00:00:54,480

It's a kind of date.



15

00:00:54,520 --> 00:01:02,580

Now if I write a date in January nineteen hundred and on top of that I'm going to go to Home Dabb apply



16

00:01:02,580 --> 00:01:06,580

the comma separator and notice it don't do do.



17

00:01:06,660 --> 00:01:08,580

Now what does this do signify.



18

00:01:08,580 --> 00:01:10,320

It signifies it is two.



19

00:01:10,360 --> 00:01:15,130

I you from the cutoff date not including the cutoff date itself.



20

00:01:15,450 --> 00:01:22,730

So for example if I think 15th of January nineteen hundred fifteen of January nineteen hundred and I



21

00:01:22,730 --> 00:01:28,080

press end up as I apply common state same manner to this particular date.



22

00:01:28,140 --> 00:01:31,290

Expect it is going to show me 15.



23

00:01:31,350 --> 00:01:34,150

Now typically you would have found this out I died.



24

00:01:34,160 --> 00:01:39,430

Then you write a formula on it beat it quickly gets converted to a numbered.



25

00:01:39,560 --> 00:01:45,200

For example you may have tried to create a formula which is supposed to give you a result of 34 December



26

00:01:45,200 --> 00:01:52,090

2011 and on your screen eventually you find the answer in this form for 0 9 0 8.



27

00:01:52,100 --> 00:01:54,000

Now what is this 4 0 9 0.



28

00:01:54,060 --> 00:01:57,990

It signifies that it is forty thousand 0.



29

00:01:58,000 --> 00:02:02,540

It does are from the cutoff date which the thirty first December 2011.



30

00:02:02,910 --> 00:02:09,960

Now this is the way Excel calculates the date if it is a number it will calculate from the cutoff date.



31

00:02:09,980 --> 00:02:15,020

How mean these it needs to add up to reach to a certain date from the calendar point.



32

00:02:15,020 --> 00:02:20,480

Now since it's a number I can also validate whether it is a valid date.



33

00:02:20,570 --> 00:02:21,120

How.



34

00:02:21,140 --> 00:02:23,490

By using a formula called number.



35

00:02:23,510 --> 00:02:26,850

For example if I write equal is number.



36

00:02:26,870 --> 00:02:27,780

This is the formula for.



37

00:02:27,830 --> 00:02:33,160

Simply asks whether the contained is a number or not.



38

00:02:33,500 --> 00:02:34,580

And it says to.



39

00:02:34,730 --> 00:02:37,130

Now why is this useful at times.



40

00:02:37,220 --> 00:02:44,270

You might be worried whether the day that you are looking at on Excel sheet may not be correct beat



41

00:02:44,360 --> 00:02:46,210

in terms of format.



42

00:02:46,250 --> 00:02:52,280

Now that would clear trouble that would create obstacles then you're doing a lot of data based calculation.



43

00:02:52,280 --> 00:02:58,630

So you want to check whether it's a valid date in which case you may simply write the formula is number



44

00:02:58,790 --> 00:03:01,140

and choose the cell before it.



45

00:03:01,160 --> 00:03:05,090

Now if it's not a date it's not understood by Excel it will say for.



46

00:03:05,170 --> 00:03:07,310

So I don't know about these formats in the deal.



47

00:03:07,310 --> 00:03:08,220

A little later.



48

00:03:08,360 --> 00:03:12,030

But this is a formula which helps validate the accuracy of a D.



49

00:03:12,250 --> 00:03:13,160

Is this a number.



50

00:03:13,160 --> 00:03:15,380

If yes then yes it is Arbet.