Hi all,

I've created the following formula =IF($D7="pc",($F7-$E7+1),"") in column
K which is a formula that leaves the number of days between two periods F7 &
E7 if D7 is "pc".

Anyway I then drag this formula down column K and instead of leaving the
correct number it just leaves the value of the first box K7. Even though the
formula changes as you go down the rows correctly it just leaves the first
value. Where as each row is a different date.

When I type the formula manually into row 8 it then calculates that row
correctly but when dragged down it just leave the value for row 8 instead of
7.

Please help me as I've looked at all the formatting for said columns and
double checked the coding but all seems to be correct.....however with
incorrect answers.

Help genuinely appreciated.