On Tue, 25 Oct 2005 13:38:12 -0700, Budman
wrote:

I need to assign a week date to a given set of warehouse numbers.. As example
6031 = Wednesday, 7033 = Thursday ect... I have 39 #'s to apply the weekly
format to.

Wisdom...

Thank you

LO

Is there any system as to how these numbers are assigned?

What is the "weekly format"?

With the limited information you provide, I can only suggest a lookup table.
Look at HELP for VLOOKUP.


--ron