O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Dates and Times

Dates and times are other important values you can enter in Excel. Treating dates and times as values makes your life easier. For example, instead of counting the number of days in the current accounting cycle or determining the age of an accounts receivable account, Excel can do the work for you.

Excel keeps track of the dates you enter by assigning each date with a serial number. The first date, January 1, 1900, is assigned the number 1; January 2, 1900, the number 2; and so on. A date can be displayed in many different formats, but Excel always keep track of the date's underlying serial number. Accordingly, you can use the dates in your calculations.

When you enter a date, you can choose to enter the year in two-digit ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required