Bi weekly formula...

[Iain McBride]

Hi - trying to formulate a Gantt chart to allow me to show where some of our employees will be on a daily basis.

So far I have the formula:
=IF(AND(G$8="Tues",G$9>=$D17,G$9<=$E17),"X","")

This allows me to highlight where people are (in this example) every Tuesday - is there a way to highlight the areas they work on a bi-weekly basis?

Thanks in advance

Iain

 

[James006]

To answer your every OTHER Thursday question ...

You can test the following formula

=IF(AND(P$8="Thur",P$9>=$D10,P$9<=$E10,OFFSET(P10,0,-7)=""),"X","")

 

[Iain McBride]

1) yes
2) F8 is that day of the week Mon, G8 is Tues, H8 is Wed and so one, as needs the date to correlate with the formula to recognise the day of the week.

 

[James006]

1) yes
2) F8 is that day of the week Mon, G8 is Tues, H8 is Wed and so one, as needs the date to correlate with the formula to recognise the day of the week.

Thanks ...

Have you tested the formula suggested in message #11 ...?

The only thing I was trying to point out ...is that despite the fact you are using actual dates in row 9 ... your row 10 does not take advantage of the custom format feature :wink: .... ( no problem ...)

 

[Iain McBride]

James - you are a star - thank you for that - I would NEVER have got my head around that!!!
I have also amended the date - ty!!!

 

[James006]

James - you are a star - thank you for that - I would NEVER have got my head around that!!!
I have also amended the date - ty!!!

Glad you could fix your problem ...:wink:

Thanks a lot ... for your Thanks ...