Microsoft Office Tutorials and References
In Depth Information
Breaking a Date with DAY, MONTH, and YEAR
Breaking a Date with DAY,
MONTH, and YEAR
That which can be put together can also be taken apart. In the preceding
section, I showed you how to use the DATE function to create a date from
separate year, month, and day data. In this section, you find out how to do the
reverse — split a date into individual year, month, and day components using
the DAY, MONTH, and YEAR functions. In Figure 12-4, the dates in column A
are split apart by day, month, and year, respectively, in Columns B, C, and D.
Figure 12-4:
Splitting
apart a
date with
the DAY,
MONTH,
and YEAR
functions.
Isolating the day
Isolating the day part of a date is useful in applications where just the day,
but not the month or year, is relevant. For example, say you own a store and
want to figure out whether more customers come to shop in the first half or
the second half of the month. You’re interested in this trend over several
months. So the task may be to average the number of sales by the day of the
month only.
The DAY function is useful for this because you can use it to return just the
day for a lengthy list of dates. Then you can examine results by the day only.
Search JabSto ::




Custom Search