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.

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.

Excel: Incorrect Weekend Markings in Feb 2023 Schedule

Reply | New topic

#1 20404572 25 Jan 2023 15:34

opero opero

Level 11
» | 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 Download (17.29 KB)
ADVERTISEMENT
#2 20405093 25 Jan 2023 20:36

Maciej Gonet Maciej Gonet

VBA, Excel specialist
» | 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 Download (17.55 KB)
#3 20405204 25 Jan 2023 21:38

opero opero

Level 11

» | 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.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the 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