I have to import a file into Excel once per week. The data could change on
any record going back to the 1st of the year. It is run for the whole year
every week.

I am doing counts on many things broken out by week. I need to convert
(automatically) the date into a code number (1/01/05 = 1; 1/10/05 = 2...) so
that as I import or paste the new weekly data into the spreadsheet the date
will automatically update a new field with the corresponding code.

I can't seem to get it to work, I was hoping one of ya'll mught have an idea.

Thanks in advance for any info!