# How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016) [closed]

So far, I have a long, complicated "IF" statement, using WEEKDAY().. There must be an easier way!

Create a table with two columns. First column has numbers 1 to 7 and second column text Sun.... Sat. Label this table DayOfWeek.

Then use the formula =vlookup(weekday(A1, 1),DayOfWeek,2)

Eg A1 = Date(2000,3,23) result should be Thu