Birthdays and Weekdays: Converting Dates To Weekdays In Excel


Ever wonder what day of the week you were born on?  Let's figure it out in Excel!

The first method uses the WEEKDAY() function to return a number from 1 (Sunday) to 7 (Saturday).

The second method uses the TEXT() function to specify a format of "ddd" (for the 3-letter abbreviation) or "dddd" (for the full word) and returns the text day of the week in text.

What day of the week were you born on?  Try it out!

Need additional help with WEEKDAY(), TEXT(), or other Excel formulas?  Reach out to us today by live chat, email, or call us at 877.851.0132.