Could someone tell me why weekends are not marked correctly in the attached schedule? In January 2023 it worked properly, and in February it no longer marks correctly.

This would be a reversal of the formula used for conditional formatting: Code: TextLog in, to see the code .

In the fifth line, you have dates, not just day numbers. The FW formula treated this fifth row as day numbers.

Thanks a lot. And is there any other simple possibility, without auxiliary tables or scripts, to automatically enter in the schedule that if it is not a weekend or a holiday, then to enter 1 in the cell? As in the screen below.

Is this supposed to be a formula?

As it would be possible to do so.

Excel: Incorrect Weekend Markings in Feb 2023 Schedule - Days Off + Holidays in Color

opero 1014 5

Treść została przetłumaczona

Zobacz oryginalną wersję tematu

Report a violation of the law

Reply | New topic

#1 20404572 25 Jan 2023 15:34

opero opero

Level 11

Posts: 19

Rate: 9
» | Topic author Helpful post? (0)

Post #1
20404572 25 Jan 2023 15:34

Could someone tell me why weekends are not marked correctly in the attached schedule? In January 2023 it worked properly, and in February it no longer marks correctly.

Attachments:

Grafik.xlsx (17.29 KB) You must be logged in to download this attachment.
ADVERTISEMENT
#2 20405093 25 Jan 2023 20:36

Maciej Gonet Maciej Gonet

VBA, Excel specialist

Posts: 2207

Help: 821

Rate: 478
» | Helpful post? (0)

Post #2
20405093 25 Jan 2023 20:36

In the fifth line, you have dates, not just day numbers. The FW formula treated this fifth row as day numbers.

Attachments:

Grafik.xlsx (17.55 KB) You must be logged in to download this attachment.
ADVERTISEMENT
#3 20405204 25 Jan 2023 21:38

opero opero

Level 11

Posts: 19

Rate: 9
» | Topic author Helpful post? (0)

Post #3
20405204 25 Jan 2023 21:38

Thanks a lot.
And is there any other simple possibility, without auxiliary tables or scripts, to automatically enter in the schedule that if it is not a weekend or a holiday, then to enter 1 in the cell? As in the screen below.
ADVERTISEMENT
#4 20405246 25 Jan 2023 22:00

Maciej Gonet Maciej Gonet

VBA, Excel specialist

Posts: 2207

Help: 821

Rate: 478
» | Helpful post? (0)

Post #4
20405246 25 Jan 2023 22:00

Is this supposed to be a formula?
ADVERTISEMENT
#5 20405296 25 Jan 2023 22:23

opero opero

Level 11

Posts: 19

Rate: 9
» | Topic author Helpful post? (0)

Post #5
20405296 25 Jan 2023 22:23

As it would be possible to do so.
Helpful post

#6 20405353 25 Jan 2023 22:54

Maciej Gonet Maciej Gonet

VBA, Excel specialist

Posts: 2207

Help: 821

Rate: 478
» | Helpful post? (+1)

Helpful post
Post #6
20405353 25 Jan 2023 22:54

This would be a reversal of the formula used for conditional formatting:
Code: Text
Log in, to see the code
.

Attachments:

Grafik1.xlsx (18.46 KB) You must be logged in to download this attachment.
Create an account, log in here. You will receive points by participating in discussions.
Join this discussion.

Install Elektroda application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

Excel: Incorrect Weekend Markings in Feb 2023 Schedule - Days Off + Holidays in Color

Didn't find an answer? Ask Artificial Intelligence