Ask Your Question

Calc: AutoFilter on WEEKDAY column

asked 2019-06-04 10:25:27 +0100

sharyl93 gravatar image

updated 2020-08-07 03:09:29 +0100

Alex Kemp gravatar image

I have a column that is populated by the WEEKDAY function, pointing to the date column next to it, so as to give the day-of-the-week that an event occurred.

I have applied AutoFilter to the sheet, but the drop-down filter value list does not populate correctly for this column - the only value available to select is "1900 > January"

image description

Is there a workaround for this?

edit retag flag offensive close merge delete


Are you applying Date format (to show weekday name) to the output of WEEKDAY function? That's absolutely incorrect... That is the reason for your problem actually.

To see your mistake, instead of format NNN, try applying format NNNNDD MMMM, YYYY

Mike Kaganski gravatar imageMike Kaganski ( 2019-06-04 11:27:06 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-06-04 11:06:10 +0100

ebot gravatar image

Have a look in the Menu Tools>LibreOffice>General.

image description

edit flag offensive delete link more


I played with this, but unfortunately it doesn't have any effect.

The problem is that I would like to see Monday, Tuesday, ... etc. in the filter drop-down but the output of the WEEKDAY function seems to be interpreted incorrectly by AutoFilter.

sharyl93 gravatar imagesharyl93 ( 2019-06-04 11:15:15 +0100 )edit

answered 2019-06-04 11:36:28 +0100

sharyl93 gravatar image

So the correct answer is to not use the WEEKDAY function at all, as Mike Kaganski mentions.

If I use the formula =TEXT(C10, "DDDD") to obtain the day-of-the-week name instead, as recommended here, then AutoFilter works as desired:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-04 10:25:27 +0100

Seen: 76 times

Last updated: Jun 04 '19