• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 2. Entering Data > Adding Dates and Times

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint