When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different methods of extracting day information that you should know.
Contents:
Examples
1. How to Extract the Day Number From a Date
Excel has a built-in function that will automatically extract the day number from any date. This will give us the second column, highlighted in table above.
It's as easy as using the DAY function, and dropping in the date that you wish to extract the day out of.
= DAY(date)2. How to Extract the Day Name From a Date
What if we instead want to return the names of the days of the week? We can use a simple formula to accomplish this as well.
To return the day names as seen in the third, highlighted, column in the table above, we can use the following formula:
= TEXT(WEEKDAY(date),"dddd")The WEEKDAY function will return a number 1-7 depending on the input date/day of the week.
This number is then converted into a text format by using Excel TEXT function, using the "dddd" format, writing out the day of the week in full text format.
3. How to Extract Abbreviated Day Name From a Date
Similar to the previous example, we can also return the abbreviated day name if needed.
By changing our formula to use three d's instead of four, the TEXT function will automatically return the abbreviate day names:
= TEXT(WEEKDAY(date),"ddd")