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 ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
