check date to see if it's weekend, conditional formatting

**DMR1712** · 04-09-2010, 06:01 AM

Hello everyone,

I would like to use a conditional formatting formula which indicates whether a date is a weekend day, is this possible? To make it extra challeging (/annoying), it has to be in one line, because I can only use 3 conditions (openoffice calc) and am already using 2.

Thanks in advance!!

Best,
DMR1712

**deemo** · 04-09-2010, 06:33 AM

If your date is in A1 then use this formula for your conditional formatting rule:

=(WEEKDAY(A1)-6)>=0

**teylyn** · 04-09-2010, 06:41 AM

deemo, not quite.

Weekday() returns 7 for a Saturday and 1 for a Sunday, unless used with the second parameter. Without this parameter the statement for conditional formatting needs to be

=OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7)

**deemo** · 04-09-2010, 06:47 AM

Ouch! Sorry about that... (red faced)

**DonkeyOte** · 04-09-2010, 06:53 AM

For sake of OP perhaps simplest to use:

=WEEKDAY(A1;2)>5

**DMR1712** · 04-09-2010, 07:44 AM

I used the last one, works like a charm!

thanks for your help.

best regards,
DMR1712

check date to see if it's weekend, conditional formatting

LinkBack

Thread Tools

Rate This Thread

Display

check date to see if it's weekend, conditional formatting

Re: check date to see if it's weekend, conditional formatting

Re: check date to see if it's weekend, conditional formatting

Re: check date to see if it's weekend, conditional formatting

Re: check date to see if it's weekend, conditional formatting

[SOLVED] Re: check date to see if it's weekend, conditional formatting

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions