Help with Condtional Formating to not highlight Saturdays & Sundays

**SKEEEETER** · 08-30-2019, 08:21 PM

I am looking to see if there is a way to exclude weekends from a employee attendance register, it all works perfect, except in the visual calendar.

It use conditional formatting to color on a calendar what type of leave it is, no one works weekends.

If you input single days all fine, but when say enter 2 weeks it colors the weekends as well. Is there a way this can not occur.

This is the formula for for the conditional formatting.

=(MONTH(H9)=MONTH($C9))*(COUNTIFS(lstEmpNames,valSelEmployee,lstSdates,"<="&H9,lstEDates,">="&H9,lstHTypes,Settings!$C$2)>0)

Capture.PNG

It colors it different depending on type of leave this all works fine, just wondering if there is a way so the Saturday & Sunday don't get colored.

**FDibbins** · 08-30-2019, 08:43 PM

1 of 2 ways, depending on if you have actual dates in row 8 or day letters.. If letters, then something like...
=h$8<>"s"

or
Take a look at the WEEDAY function.
=

**SKEEEETER** · 08-31-2019, 04:14 PM

Thanks for your reply, I have tried various ways to incorporate your 1st suggestion into the existing formula but unable to get it to work.

In row 8 is only letters.

Please Login or Register  to view this content.

I am not sure exactly where it should appear either.

**Pete_UK** · 08-31-2019, 04:21 PM

You might get other people to respond if you attach a sample Excel workbook, rather than a picture of one.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete