You have a list of dates and you need to know what are the days of these dates – Monday, Tuesday, Friday?
The formula to be used in =TEXT.
Simply enter the formula as below,
For the Day name in 3 characters, like Mon, Tue, etc., use this
=TEXT ( date cell reference, “DDD“)
For the Full Day name, like Monday, Tuesday, etc., use this
=TEXT ( date cell reference, “DDDD“)