I am PhD student and working on some traffic counting cards,
the card has 2500 rows and one column, the column has numbers from 1 to 31 covering the month days, but each number is written 96 times (96 * 31 = 2900 which is the number of the rows).
how can i convert the numbers to day names?
for example number one what day was it in Jan 1st 2007?
how can i do that to the whole cells?