convert weekday string to number

[Guest]

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!

 

[Don Guillett]

Have a look in HELP index for LOOKUP

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

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