Forum Discussion

K-Metry's avatar
K-Metry
Copper Contributor
Sep 08, 2025

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 the day name as text to use it in conditional format using day names ?

any help ???

excel
Formulas and Functions

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 08, 2025

    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.

Resources