Microsoft Excel Functions & Formulas

Use the DAY function to extract the day

part of a date

Once again, use the worksheet from the previous two examples.

Column A contains dates in different formats. To determine the day

part of a date, use the DAY function. This function returns the day

corresponding to a date as an integer in the range 1 to 31.

4

To extract the day as 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:

=DAY(A2).

3. Press <Ctrl+Enter>.

Note: If the day part is missing (see rows 5 and 6), the

function returns the value 1.

104 Chapter 4

Figure 4-13