Microsoft Excel Functions & Formulas

Use the MONTH function to extract the month

part of a date

For this tip use the worksheet from the previous example. Column

A contains dates formatted in different ways. To determine the

month part of a date, use the MONTH function. This function

returns the month corresponding to a date as an integer in the

range 1 to 12.

4

To extract the month part of a date:

1. In cells A2:A10 generate a list of dates using different

formats.

2. Select cells B2:B10 and type the following formula:

=MONTH(A2).

3. Press <Ctrl+Enter>.

Date and Time Functions 103

4

Figure 4-12