Conditional formatting excluding weekends and holidays

  • Thread starter Thread starter Andrew Owenson
  • Start date Start date
A

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
 
Back
Top