Entering date values

Excel handles dates by using a serial number system. The earliest date that Excel understands is January 1, 1900. This date has a serial number of 1. January 2, 1900, has a serial number of 2, and so on. This system makes it easy to deal with dates in formulas. For example, you can enter a formula to calculate the number of days between two dates.

Most of the time, you don’t have to be concerned with Excel’s serial number date system. You can simply enter a date in a familiar date format and Excel takes care of the details behind the scene.

For example, if you need to enter June 1, 2007, you can simply enter the date by typing June 1, 2007 (or use any of several different date formats). Excel interprets your entry and stores the value 39234, which is the date serial number for that date.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>