Hello all.

Happy new year and welcome back to work. Appreciate if I can get help on the
following:

In Range A1 to A10 I have dates.
In Range B1 to B10 I have a number between 1 and 100.

I require a formula (or macro) in range C1 to C10 to count the number of
days between today and the date in the corresponding cell in range A1 to A10.
But, Once the corresponding cell in range B1 to B10 = 100 I require the
formula(macro) to retain the final number of days counted.
--
Cheers
Ant.