Advanced Dynamic Ranges
dynamic range uses a named range based on the COUNTA formulae:
However, this only works where there are no blanks in the data. If the data is purely numeric, and contains blank cells in the data then use a range such as:
If the data is purely text then we will need a named range such as:
And if we have a mixture of text, numbers and spaces:
Where we take the maximum of the two previous match functions.
If we need a range that expands for every day of this calendar year: