Drawback of Microsoft 1900 Date system.

Today we are going to discuss about the drawbacks of Microsoft 1900 date system.

Microsoft Excel uses two different date systems: the 1900 date system and the 1904 date system. By default Microsoft Excel use the 1900 date system. Microsoft use 1900 date system because the 1900 date system allows greater compatibility between Microsoft Excel and other spreadsheets program such as Lotus 1-2-3.

Drawback of Microsoft 1900 Date system.

The 1900 date system suppose that the year 1900 is a leap year where it is false. due to this every time when we calculate date differences it show 1 day more than actual differences.

Click here for show the actual 1900 calender.
click here for show the Microsoft 1900 date system calendar.


Note:- The 1900 date system suppose that 1st Jan 1900 is the 1 day and the 1904 date system suppose that 1st Jan 1904 is the 1 day. The differences between both date system is 1462 days.

HOW EXCEL CALCULATE DATE AND TIME

Do you know how excel understand date and time system..........

It is very easy and simple process.
By default excel use the 1900 date system. excel does not calculate any date before the 1900 date system. okay now what is the process. Excel count the date difference from 1st Jan 1900. That means 1st Jan 1900 is the first day according to excel and 2nd Jan 1900 is the 2nd day and so on.

Example:- Let if you entered 7th nov 1983 then the serial value of date will be 30627

Now you can use the datedif function in excel to calculate the differences between two day.

So I hope now you understand that how excel understand the date. In which process excel understand date the process is called serial value of date.

Now you must be want to know how excel understand the value of time.
So it is also simple. Excel understand time as decimal fractions. That means 24:00 or 12:00 AM excel assumed that time as whole number 1.
Example if the time is 18:00 then its value is 0.75.
if the time is 15:00 then its value is 0.625

So now you understand how excel see date and time.
Here we see some example:

If Date and time is 7th Nov 2009 and the time is 20:30 then the serial value is 40124.85417


So my dear friends now tell me if the date and time is 7th Nov 2009 and the time is 24:00 what is the serial value in excel.
If you have any question or comments please send it to me..............

Have a good day friend.

Examples of formulas.....................

Hi..............friends...................

Today I am going to share few links with u.
All those links included examples of formulas.........
Every link is important according to my view.....
The more you learn the more you get..........
So the links are bellow..........

http://office.microsoft.com/en-us/excel/HP052001271033.aspx

http://www.cpearson.com/excel/excelF.htm

http://www.educationonlineforcomputers.com/blogs/post/microsoft_office_training_tutorial/574/187-Excel-Formula-Tutorials-and-Examples


http://www.xlfdic.com/

http://www.free-training-tutorial.com/formulas.html

http://office.tizag.com/excelTutorial/excelformulas.php

so thats it..................a lot of links are available...............but you have to learn and search for it.........

Remember one important thing friends...........
A forumla is nothing more than an equation that you write up. In Excel a typical formula might contain cells, constants, and even functions. Here is an example Excel formula that we have labeled for your understanding.