Use the DAY function to extract the day part of a date - Date and Time Functions - Microsoft Excel

Use the DAY function to extract the day part of a date using Microsoft Excel

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.

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->.

Use the DAY function to extract the day part of a date

Note: If the day part is missing (see rows 5 and 6), the function returns the value 1.

Watch the Video Tutorial - https://www.youtube.com/watch?v=dQaRsEH7ZS8