Conditional formatting excluding weekends and holidays
 

I am trying to creat a chart where you put a start date and a finish
date in and the chart will colour some squares to the right. I can do
all of that but it overcolours the weekends and counts them as days.
How can I set it that the squares will only colour weekdays only and
not weekends or holidays and not count them as days.

Regards

Andrew

Conditional formatting excluding weekends and holidays
 

Sounds like the NetWorkDays function could help.
--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
editorial review of special sort excel add-in (30 ways to sort)



"Andrew Owenson"
wrote in message
...
I am trying to creat a chart where you put a start date and a finish
date in and the chart will colour some squares to the right. I can do
all of that but it overcolours the weekends and counts them as days.
How can I set it that the squares will only colour weekdays only and
not weekends or holidays and not count them as days.

Regards

Andrew