Excel gurus:

I found a function that returns a number from 1 to 7 representing a weekday. Is there a function that returns the name of the day instead? Or is there a function that turns the number into a weekday name?

Hi
Hardcoded:
=LOOKUP(WEEKDAY(A1,2),{1;2;3;4;5;6;7},{"Monday","T uesday","Wednesday","Thursday","Friday","Saturday" ,"Sunday"})

Or a better idea. Say in cells G1:G7 you have the numbers 1-7 & H1:H7 you have Monday-Sunday.

=LOOKUP(WEEKDAY(A1,2),$G$1:$H$7)

If your week begins on Sunday then just Custom format your cell as "ddd"

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The custom formatting works great also. Thanks to both of you.