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" <(E-Mail Removed)>
wrote in message
news:1c97b2d5-2041-4991-a1a6-(E-Mail Removed)...
>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