Microsoft Office Tutorials and References
In Depth Information
Dates and Times in Excel
Figure 11.34.
Figure 11.34. A team of astronomers probably worked for hours to calcu-
A team of astronomers probably worked for hours to calcu-
late what now takes seconds in Excel.
late what now takes seconds in Excel.
Around Y2K, someone decided that 1930 is the dividing line for
two-digit years. If you enter a date with a two-digit year, the res-
ult is in the range of 1930 through 2029. If you enter 12/31/29, this
will be interpreted as 2029. If you enter 1/1/30, it will be inter-
preted as 1930. If you need to enter a mortgage ending date of 2040,
for example, be sure to use the four-digit year, 6/15/2040.
The point is that Excel dates are nothing to be afraid of. You need to under-
stand that behind the scenes, Excel is storing your dates as serial numbers
and your times as decimal serial numbers. Occasionally, circumstances
cause a date to be displayed as a serial number. Although this freaks some
Search JabSto ::




Custom Search