To Excel, a date is simply a number. More precisely, a date is a serial number that represents the number of days since the fictitious date of January 0, 1900. A serial number of 1 corresponds to January 1, 1900; a serial number of 2 corresponds to January 2, 1900, and so on. This system makes it possible to deal with dates in formulas. For example, you can create a formula to calculate the number of days between two dates (just subtract one from the other).

Excel supports dates from January 1, 1900, through December 31, 9999 (serial
number = 2,958,465). You may wonder about January 0, 1900. This nondate (which corresponds to date serial number 0) is actually used to represent times that aren’t associated with a particular day. This nondate business becomes clear later in this chapter (see the section “Entering times”).

To view a date serial number as a date, you must format the cell as a date. Choose Home?Number? Number Format. This drop-down control provides you with two date formats.

• Tips For Searching The Best Christian Dating Services Free online Christian dating is easily available to Christians who are looking for friends or life partners. Christian singles who...
• Reminiscing with Fat Pictures from 2005 I was cleaning up the computer in my garage when I came across some pictures I took back in January...
• No Year's Resolution I know this seems strange considering that I am currently holding a 2009 Financial Resolutions Blog Contest, but I don't...
• adidas Men's Tirand III Tennis Shoe,White/Black/Red,11 M User Reviews Send this to a friend adidas Men's Tirand III Tennis Shoe,White/Black/Red,11 M Manufacturer: adidas Customer Rating: List Price:...
• Dating and Gift Giving: What to do? ======================================= Dating and Gift Giving: What to do ======================================= What are the best types of gifts to give to someone...