I need to =a set of numbers to a given week day.ie 6031 = Wed ect

B

Budman

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
C

CLR

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
 
Top