Conditional formatting excluding weekends and holidays

[Andrew Owenson]

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

 

[Jim Cone]

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" <[email protected]>
wrote in message
news:1c97b2d5-2041-4991-a1a6-d8b5e966ec6d@bs8g2000vbb.googlegroups.com...