Use the DAY function to extract the day part of a date using Microsoft Excel
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.
Watch the Video Tutorial - https://www.youtube.com/watch?v=dQaRsEH7ZS8
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 |
Watch the Video Tutorial - https://www.youtube.com/watch?v=dQaRsEH7ZS8
No comments:
Post a Comment