macro for a range

F

Fats

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top