Ask Your Question

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

asked 2017-08-03 10:54:49 +0200

peter.strnad gravatar image

updated 2017-08-03 20:58:54 +0200

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.


edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2017-08-03 11:21:12 +0200

JohnSUN gravatar image

updated 2017-08-03 11:30:56 +0200

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

Format cell

edit flag offensive delete link more

answered 2017-08-03 19:19:23 +0200

Lupp gravatar image

updated 2017-08-03 19:20:30 +0200

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.

edit flag offensive delete link more

answered 2017-08-03 20:58:39 +0200

peter.strnad gravatar image

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.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-03 10:54:49 +0200

Seen: 1,135 times

Last updated: Aug 03 '17