Hi there,

I am trying to reference a range that changes as each day goes by.
Currently its A2:A500....Tomorrow it will be A2:A501 etc etc.

So I am trying something like this but its not working A2:Count(A2:A10000).
I think i might need to use offset but not sure.

Thanks a lot

SD