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

Entering Dates and Times

Dates that you enter into an Excel workbook have numerical significance. Excel converts the date into a number that reflects the number of days that have elapsed since January 1, 1900. Even though you won't see this number (Excel displays your entry as a normal date), the number is used whenever you use this date in a calculation. Times are also considered values. Excel sees them as the number of seconds that have passed since 12 a.m.

Follow these steps to enter a date or time:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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