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