Sorry I forgot to say that a date in 1 cell would mean an addition and a date
in a different cell would mean a subtraction.

"Annerobbo" wrote:

I need a formula so that if a date is entered in a cell on one worksheet a
cell on another worksheet will add or subtract a 1 to the total that is
already there.

Thanks