Get Day Name from Date (TEXT formula)

Have you ever needed to find the day name (i.e. Monday, Tuesday, Wednesday, etc…) from a date?

Well, the solution is very simple.

You can use a TEXT function

Example

=TEXT(A1,"dddd") for full day name (i.e. Monday)

and

=TEXT(A1,"ddd") for short day name (i.e. Mon)

Try it yourself and see the magic!

#Text #Excel