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

Entering Dates and Times

After you enter a date or time into a cell, Excel converts the date into a number that reflects the number of days between January 1, 1900 and that date. 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.

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