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

Entering Dates and Times

You can enter dates and times in a variety of formats. When you enter a date using a format shown in Table 5.1, 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. By the way, the feature that automatically formats your data based on the way you enter it is called AutoFormat.

Table 5.1. Valid Formats for Dates and Times
FormatExample
M/D4/8
M-YY4-58
MM/DD/YY4/8/58 or 04/08/58
MMM—YYJan—92
MMMMMMMMM-YYSeptember-93
MMMMMMMMM DD, YYYYSeptember 3, 1993
DD—MMM—YY28—Oct—91
DD—MMM6—Sep
HH:MM16:50
HH:MM:SS8:22:59
HH:MM AM/PM7:45 PM
HH:MM:SS AM/PM11:45:16 AM
MM/DD/YY HH:MM11/8/80 4:20



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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