Microsoft Office Tutorials and References
In Depth Information
Jun18
June 18 of the current year
18-Jun
June 18
June 18 of the current year
18-Jun
June18
June 18 of the current year
18-Jun
6/18
June 18 of the current year
18-Jun
6-18
June 18 of the current year
18-Jun
18-Jun-2013
June 18, 2013
18-Jun-13
2013/6/18
June 18, 2013
Windows short date
As you can see in Table 6-1, Excel is pretty good at recognizing dates entered into a cell. It's not perfect,
however. For example, Excel does not recognize any of the following entries as dates:
• June 18 2013
• Jun-18 2013
• Jun-18/2013
Rather, it interprets these entries as text. If you plan to use dates in formulas, make sure that Excel can recog-
nize the date that you enter as a date; otherwise, the formulas that refer to these dates will produce incorrect res-
ults.
If you attempt to enter a date that lies outside of the supported date range, Excel interprets it as text. If you at-
tempt to format a serial number that lies outside of the supported range as a date, the value displays as a series
of hash marks (#########).
If you want to be absolutely sure that a valid date is entered into a particular cell, you
can use Excel's data validation feature. Just set it up so the validation criteria allow
only dates. You can also specify a valid range of dates. See Chapter 20 for more about
data validation.
Searching for dates
If your worksheet uses many dates, you may need to search for a particular date by using the Find and Replace
dialog box (Home⇒Editing⇒Find & Select⇒Find, or press Ctrl+F). Excel is rather picky when it comes to finding
dates. You must enter the date as it appears in the Formula bar. For example, if a cell contains a date formatted to
display as June 18, 2013, the date appears in the Formula bar using your system's short date format (for ex-
ample, 6/18/2013). Therefore, if you search for the date as it appears in the cell, Excel won't find it, but it will find
the cell if you search for date in the format that appears in the Formula bar.
Search JabSto ::




Custom Search