View Single Post
  #1   Report Post  
nico
 
Posts: n/a
Default 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!