Forum Discussion
copy day name by value only from cell containing =today() function
is this any way to copy day name (text only) only from cell containing =today() function i set A1=TODAY() and i set format to dddd so the today name is displayed i want to set A2 cell to be set to...
In A2 either
=TEXT(A1, "dddd")
or
=TEXT(TODAY(), "dddd")
If you use the latter, you don't need the formula in A1.
It is also possible to use TEXT(TODAY(), "dddd") in a Conditional Formatting rule.