As the title suggests, I want to use an excel name to define the integer value for the R argument.

So far i have failed in getting the example function (count) to work with using names in the range designation.

I suspect that i need to somehow designate that the datatype of the excel name is an integer, but i do not know how to do that in excel at the worksheet level. I did go to the cell for whose content the name points to
and designated the value as a number with zero decimal places. but I suspect that excel keeps that number in floating point data type.

I am seeking to do this because I want to avoid having to select the range end cell. I want to precalculate that range end cell once and then where ever i need to perform a function use that range end cell.

It is tricky, in my case, as the range end cell is calculated by: DATEDIF(TEXT(R7C1, "dd-mmm-yyyy"), TODAY(), "d")...... This approach allows data to be missing within the data set including the most recent entry. the only requirements are that all my data starts at the first date (R7C1) and that there is a potential to record data for each day.

please help me figure out a way to use variables or constants in an excel worksheet in conjunction with the r1c1 format.

thank you
bil