Microsoft Office Tutorials and References
In Depth Information
Converting a Date from Text
3. Click the cell that has the date.
4. Enter a ), and press Enter.
Excel returns a number between 1 and 12.
Figure 12-6:
Using the
MONTH
function to
count the
number of
dates
falling in each
month.
Isolating the year
Isolating the year part of a date is useful in applications where just the year,
but not the day or month, is relevant. In practice, this is less used than the
DAY or MONTH functions because date data is often — though not always —
from the same year.
Follow the steps to use the YEAR function:
1. Select the cell where you want the results displayed.
2. Enter =YEAR( to begin the function entry.
3. Click the cell that has the date.
4. Enter a ), and press Enter.
Excel returns the four-digit year.
Converting a Date from Text
You may have data in your worksheet that looks like a date but is not
represented as an Excel date value. For example, if you enter 01-24-15 in a cell,
Search JabSto ::




Custom Search