From what you've said so far, I would use the VLOOKUP function and make a
table of your 39 numbers down a column somewhere out of the way and put the
Weekdays in the next column to the right, then use something like

=VLOOKUP(A1,YourTableRange,2,false)

Vaya con Dios,
Chuck, CABGx3


"Budman" wrote in message
...
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