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“)