Solved: calc: name of a day based on a date

[peter.strnad]

Good afternoon,

I would like to ask you for the advice with the following problem in Calc:

1. column A contains a date in the format DD.MM.YYYY
2. in column B I would like to display a name of the day (e.g. Wednesday) corresponding to the date in column A

I tried to do it with the “weekday” function, but the only thing I got was a “#VALUE” result.

Could you please help me to resolve this issue?

Thank you in advance.

Peter

[JohnSUN]

Try =TEXT(A2;"DDDD") or simply =A2 and format cell like as

[Lupp]

The WEEKDAY() function should return the index of the day within the week depending on a counting scheme that can be determined by an optional parameter. Default starts with 1 for Sunday.
If the function returns the #VALUE error, the something you called a date is most likely a text of a date-like content not recognised under your locale settings.

[peter.strnad]

Good evening,

thank you guys for your help:

1. JohnSUN. Your advice worked. I wanted to be on the safe side and I did the format of the column B and it works like a charm.
2. Lupp. You were also right. I do not know why, but I managed to put an apostrophe in a front of my date. So while in column, it looked all right, when I looked in to the input field, I noted this problem.

Thank you again for swift and helpful response.

Peter