Hi, again thanks for previous help, I would not ask had I not tried several times already, but my new question is this:
I have a column listed as the ID tag for a dataset. This column has a large number for every row, with numbers representing different values of the identification, and formated as text (by default because import procedures require this to get true values).
e.g. 1023419990516004
-Where 10234 is the agent #, 19990516 is the date (year, month, date), and 004 is the survey # for that day for that agent.
I have made previous template keeping the stats locked and can drag and drop datasets to get different statistics without manipulating columns. My hope is to extract the date, or rather use COUNTIFS the cells meet a date range (season) without creating a new column that extracts these values.
e.g. =countifs(sheet!range:range,">=....19990320...,sheet!range:range,"<=....19990620...,sheet!rang:range,(other criteria)).
Anybody have an idea on how to do this or if this is possible without formatting column as number? If not, what would I place in the format code to extract this date? Thanks
I have a column listed as the ID tag for a dataset. This column has a large number for every row, with numbers representing different values of the identification, and formated as text (by default because import procedures require this to get true values).
e.g. 1023419990516004
-Where 10234 is the agent #, 19990516 is the date (year, month, date), and 004 is the survey # for that day for that agent.
I have made previous template keeping the stats locked and can drag and drop datasets to get different statistics without manipulating columns. My hope is to extract the date, or rather use COUNTIFS the cells meet a date range (season) without creating a new column that extracts these values.
e.g. =countifs(sheet!range:range,">=....19990320...,sheet!range:range,"<=....19990620...,sheet!rang:range,(other criteria)).
Anybody have an idea on how to do this or if this is possible without formatting column as number? If not, what would I place in the format code to extract this date? Thanks