If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
macro for a range
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. |
Thread Tools | |
Display Modes | |
|
|