I am trying to convert between WEEKDAY(TODAY() and the word version for the day of the week. I would imagine it is a common need.
This works just fine.
IF(WEEKDAY(TODAY())=1,“Monday”, “”)
Why might this not work?
IF(WEEKDAY(TODAY()) = 1,”Monday”,
IF(...