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

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