I am not able to use a formatted cell within an array formula. The array
formula is set up to average the number of days it is taking to get a product
from a third party vendor and one range used in the formula is formatted and
the array formula does not like the formatted cell.
Any thoughts on how i can get around the formatted cell / format the cell
where the array formula will accept the formatted cell?
Thanks,

Michael