Hello everybody in this video session I talk about the concept of Beat the way they're stored in a cell
and why should you know this.
Well if you happen to work with the formulas or if you happen to clean it up when the dates are in the
wrong format you must know this prerequisite.
We exist towards the deed.
If you don't then you will not be able to perform do the deed or cleaning exercises successfully.
And at times you'll find difficulty in writing if a with respect to leaks.
So let's see what lies ahead.
Well to start with every valid bid in Excel is a number.
And what is that number.
It's the number that says the number of days of it from the start of the now it might sound like a jargon.
Let me explain through this diagram.
Let's assume on our timeline there's a date called 34 December 1899.
It's a kind of date.
Now if I write a date in January nineteen hundred and on top of that I'm going to go to Home Dabb apply
the comma separator and notice it don't do do.
Now what does this do signify.
It signifies it is two.
I you from the cutoff date not including the cutoff date itself.
So for example if I think 15th of January nineteen hundred fifteen of January nineteen hundred and I
press end up as I apply common state same manner to this particular date.
Expect it is going to show me 15.
Now typically you would have found this out I died.
Then you write a formula on it beat it quickly gets converted to a numbered.
For example you may have tried to create a formula which is supposed to give you a result of 34 December
2011 and on your screen eventually you find the answer in this form for 0 9 0 8.
Now what is this 4 0 9 0.
It signifies that it is forty thousand 0.
It does are from the cutoff date which the thirty first December 2011.
Now this is the way Excel calculates the date if it is a number it will calculate from the cutoff date.
How mean these it needs to add up to reach to a certain date from the calendar point.
Now since it's a number I can also validate whether it is a valid date.
How.
By using a formula called number.
For example if I write equal is number.
This is the formula for.
Simply asks whether the contained is a number or not.
And it says to.
Now why is this useful at times.
You might be worried whether the day that you are looking at on Excel sheet may not be correct beat
in terms of format.
Now that would clear trouble that would create obstacles then you're doing a lot of data based calculation.
So you want to check whether it's a valid date in which case you may simply write the formula is number
and choose the cell before it.
Now if it's not a date it's not understood by Excel it will say for.
So I don't know about these formats in the deal.
A little later.
But this is a formula which helps validate the accuracy of a D.
Is this a number.
If yes then yes it is Arbet.