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!
