Skipping Weekends

  • Thread starter Thread starter G0DD3Rs
  • Start date Start date
G

G0DD3Rs

All,

I've got the following problem.

I want to use Excel as a type of gant chart for project reportin
purposes. I currently use conditional formatting to colour a dat
period in as a certain colour and it also colours the weekends in
different colour.

My current problem is that the date range going across a weekend wil
INCLUDE the weekend as working time, when I want to exclude weekens
Does anyone know how to achieve this?

My dates start at H2 and proceed to AK2 which covers every day i
November. The start/end range of dates is set in $C2 and $D2.

Currently trying these two as cond. formats as per a previou
suggesetion but to no avail.

=AND(H$2<>"""",WEEKDAY(H$2,2)>5)
=AND(H$2>=Start,H$2<=Finish)

Thanks

Godder
 
Conditional formatting using

=WEEKDAY(H$1,2)>=6

Will highlight your weekends.

If you want to exclude weekends from any calculations of time worke
etc then use

=networkdays(start,finish
 
Back
Top