Friday, January 20, 2012

How Excel deals with dates?

In Excel, all dates are stored as integers (Integer 1 represents January 1, 1900, integer 2 represents January 2, 1900, and so on).
As the dates are stored as integers, you can perform operations such as addition, subtraction of dates. This helps us to know the difference between two dates, and so on.
To perform operations with date, Excel provides us many built-in functions like DATE, DATEVALUE, DAY, MONTH, YEAR, and more.
/* */