Hello Bob

I was not suggesting that I delete H180 I was just informing you that
the only way that I could get your formula to work for me was to delete
the formula in H180 and unfortunately I need this formula to stay there.
The formula in H180 as got nothing to do with the above formula, it is
there so that when that person commences work here they are entered
onto another sheet which will automaticaly feed the starting date
across to this sheet and into H180. In the formula it is asking that if
H180 is = 0 then E180-$J$180, but because H180 as got a formula in it
your formula will not work for me. and as I said before it will however
only work if I delete the formual in H180. And sorry for any
misunderstanding.

Paul Maynard
Moscow
Russia


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=511618