convert weekday string to number

N

nico

Is there an easy way to convert a string which is either "Monday" thru
"Sunday" into a number to work with? In particular, I want to add a 1 if the
cell contains "Monday", 2 if "Tuesday" etc.

Any ideas?
Thanks!
 
C

CLR

=LOOKUP(A1,{"Friday",5;"Monday",1;"Saturday",6;"Sunday",7;"Thursday",4;"Tues
day",2;"Wednesday",3})

Vaya con Dios,
Chuck, CABGx3
 
B

Bob Phillips

=MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Su
nday"},0)
 
Top