Convert dates into codes
 

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!

Two suggestions:

You could use the weeknum function to convert a date into the week number.
-or-
You could create a table with the weeks in one column and the corresponding
number in the next and use a vlookup.



"Davin" wrote:

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!

Perfect!

Thanks a lot, just the "idea push" I needed. I went with the vlookup
solution and it worked like a charm.


"David Hepner" wrote:

Two suggestions:

You could use the weeknum function to convert a date into the week number.
-or-
You could create a table with the weeks in one column and the corresponding
number in the next and use a vlookup.



"Davin" wrote:

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!