Dragging 2 column formula across

[pdauction]

Hi,

I am design a formula that is easy to drag to the right.

It is interrogating 2 columns for each person (an am and a pm) to count holidays.

The formula is

=COUNTIF(Holidays!C:D,Balances!$B6)/2

B6 is just "Hol" which it is meant to calculate.

If I drag this across it is
=COUNTIF(Holidays!D:E,Balances!$B6)/2 rather than =COUNTIF(Holidays!E:F,Balances!$B6)/2

I just can't seem to find an easy way to resolve this.

Thanks as always

Kind Regards
Paul