1. Home
  2. Computing & Technology
  3. Spreadsheets

Computer Serial Date

By Ted French, About.com

Definition:

Computers store the date as a number representing the number of full days since midnight January 1, 1900 plus the number of hours, minutes, and seconds for the current day.

Excel's date and time functions, such as =NOW and =TODAY use this number for calculations involving dates or to add the current date and/or time to a spreadsheet.

On Macintosh computers, the serial date begins in January 1904.

Also Known As: Serial Date, Serial Number
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Definitions
  5. S
  6. Serial Date - Spreadsheet Terms - Spreadsheet Glossary

©2009 About.com, a part of The New York Times Company.

All rights reserved.