4

I haven´t found much searching on the net.

The case: One cell is filled out in date-format by the TODAY() function. How can I update another cell with the actual day as string? I´ve seen older examples by using CHOOSE func, or the the WEEKDAY() func formatted. Nothing seems to work for me.

5
  • What do you mean by "nothing seems to work for me"? Do you get an error message? Commented Jan 29, 2018 at 15:23
  • What have you tried that doesn't work? If you don't mention that, you're likely to get answers that suggest exactly that.
    – ale
    Commented Jan 29, 2018 at 15:52
  • 1
    Like the provided answer down here, as read on another site, that formel gives me an parser error.
    – CARTOS
    Commented Jan 29, 2018 at 18:16
  • 1
    Are you using a language other than English? If so, then you need to use semi-colons instead of commas in your functions. That may be the source of your error.
    – ale
    Commented Jan 30, 2018 at 14:33
  • English is default. Its fixed.
    – CARTOS
    Commented Feb 3, 2018 at 8:04

2 Answers 2

9
=TEXT(A1;"dddd")

where A1 is the cell with the date.

3
  • Funny: Google examples have a comma separating the fields, but it doesn't work. Using semicolon as in the answer works.
    – Diego
    Commented Sep 21, 2020 at 8:50
  • @Diego It probably has to do with your spreadsheet locale settings. It should work with comma in US locale.
    – TheMaster
    Commented Sep 21, 2020 at 8:54
  • you are correct. Anyway I found it odd that it does, bad design.
    – Diego
    Commented Sep 21, 2020 at 9:11
4

This solution works for me:

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

where A1 is the cell with the date.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.