convert weekday string to number

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!

Have a look in HELP index for LOOKUP

--
Don Guillett
SalesAid Software
donaldb@281.com
"nico" <nico@discussions.microsoft.com> wrote in message
news:A5E9B082-ACD5-4351-AAFD-B534E80074A0@microsoft.com...
> 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!

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

Vaya con Dios,
Chuck, CABGx3


"nico" <nico@discussions.microsoft.com> wrote in message
news:A5E9B082-ACD5-4351-AAFD-B534E80074A0@microsoft.com...
> 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!

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

--
HTH

Bob Phillips

"nico" <nico@discussions.microsoft.com> wrote in message
news:A5E9B082-ACD5-4351-AAFD-B534E80074A0@microsoft.com...
> 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!