Forum Discussion
Solved
If Then Help
Hey guys, I am having problems with a simple formula (it's been that kind of day). I am looking for a formula that will change the Day# in gray, when the blue day of the week changes. Monday ...
- You could also try:
="Day "&MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
If the day and weekday number are associated with an actual date, simple formatting would produce a display such as that shown.
= TODAY() [custom number format = "dddd"]
= WEEKDAY(date,2) [custom number format = "Day General"]