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.
// Related Posted - GOOGLE!
Related Websites
- AT&T blacks out employee vacation dates in June, presumably for the iPhone launch AT&T blacks out employee vacation dates in June, presumably for the iPhone launch by Greg Kumparak on April 16, 2010...
- Warpspeed Dyneema Double Braid 7/16 inch Warpspeed Double Braid, 14,000 Breaking Strength, Green An excellent value for high-performance color-coded running riggingWarpspeed is designed, like all Samson competition-grade line, for high strength and low...
- Prosper Estimated Return Guidance Pessimistic Example -- aka PML #5 -- Pay off high interest home improvement cards In my Friday post, I encouraged everyone to think for themselves when it comes to estimated return guidance. It is...
- Scratch-off lottery games WILL eat your lunch A few weeks ago I met "J" of BudgetsAreSexy.com, and Nicole of Breaking Even Communications, up in DC. It was...
- Germany Confident Can Beat Ghana Germany remains optimistic facing the last match against the opponent's weight of Ghana in Group D of World Cup 2010,...
