Formula Weekends

Hi Experts,
I have a file I have created a project sheet, but I have an issue is a sheet, I don't want the formula to read weekends days which is highlighted in red cells, any exerpt can help me?

attached image and excel file.

Thanks in advance

Aaru

It would be better to apply the highlights in row 1 for the weekends using conditional formatting, so that it will automatically follow the date when you change cell D2. Give all those cells on row 1 from column F the same formatting of a pale blue background, and then select them all (i.e. F1:FQ1) and click on Conditional Formatting | New Rule | Use a formula... , and then put this formula in the dialogue box which pops up:

=WEEKDAY(F1,2)>5

Click on the Format button | Fill tab and choose Red, then OK twice to exit the dialogue box.

The formula in F2 can be simplified to this:

=IF(AND(F$1>=$D2,F$1<=$E2,WEEKDAY(F$1,2)<6),1,"")

Copy this across and down as required.

Hope this helps.

Pete

Thanks, Pete, also I want the chart with blue highlighted weekends should be in red, I think confusing to explain but if you see pic can understand.

Read my first paragraph. It tells you how to apply conditional formatting to those cells in the range from F1 and across in order to show them as red if the date is for a weekend. As your start date in F1 is dependent on your first project start date in D2, you cannot have fixed formatting to turn them red, as your first project start date could be any day of the week.

OR, do you mean those gaps between the horizontal blue bands should be red as well? If so, then you will need another CF rule with a formula which detects if the date is between the start and end dates for that project and it is a weekend. You keep changing your requirements (and colours) - your first picture does not show this.

Hope this helps.

Pete