Problem with coloring weekdays as red in automated calendar

Hello guys!

I have a microsoft document which is an automated calendar. It changes automatic the days when u write in your prefeered date in cell B6.

What i am trying to do is to highlight the weekends, with an automated calendar. I have tried to search the google etc, but nothing is working.

I have tried to: =weekdays(C$9,2)>5
=Or(weekdays($C$9,2)>5 etc...

Anyone who can give me an helping hand here? Not getting it to work.


Appreciate your help a lot, thank you if you can manage to help me with this task.

Skjermbilde 2019-03-01 kl. 12.55.36.png

Thanks again!

It wont work for me, I get an error when I copy your formula. It says a formula must start with "=" etc...
What cells did you mark before entering the formula?

I still get this message when doing as you said...I just dont understand what I am doing wrong...
Skjermbilde 2019-03-01 kl. 14.00.52.png

Appreciate you guys taking your time, I really do.

Although your profile says that you are in London, the screen shot indicates that you are using a different language than English (is it Dutch ?). As well as using semicolons instead of commas in the formula, you will need to translate the function name WEEKDAY into your language.

As Trevor had attached a file for you, if you open this it will have done the translation for you.

Hope this helps.

Pete

Thank you all for your help. I really appreciate it big time! Have a great day! <3

Ali,

Location in the profile is a bit misleading in this case, where the physical location may well be London, but a different language is being used on the PC than what you would expect for that location. I've come across a few of these over the years.

Pete