Run into this all the time, people want to have a weekday or month returned as text, instead of 1,2,3…
What do you do: you create a small table with a vlookup or index to pull the name based on the number, right?
Much easier:
=TEXT(WEEKDAY(A1);”dddd”) for days (or use “ddd” for 3-digit shortnames, lik “Fri”)
=TEXT(MONTH(A1);”mmmm”) for months
You can also use the WEEKDAY or MONTH formula, and then format the cell, select custom and type ‘dddd’ for the full name of the day.
Same works for months: get the month with =MONTH(A1) and just custom format the cell to ‘mmmm’ and voila.
