If I understand correctly coding Monday to 1, Tuesday to 2 etc will
create one variable for days of the week and assume that tuesday is
double monday! I don't think this is what you want.

You need to create 7 variables
One for each day eg 1 if monday 0 if not as one variable, 1 if tuesday
0 if not etc. Although arguably you could get way with six variables as
if it is not mon-sat it has to be sunday!
day mon tue wed thu fri sat sun
Monday,1,0,0,0,0,0,0
Tuesday,0,1,0,0,0,0,0
Wednesday,0,0,1,0,0,0,0
Thursday,0,0,0,1,0,0,0
Friday,0,0,0,0,1,0,0
Saturday,0,0,0,0,0,1,0
Sunday,0,0,0,0,0,0,1


Regards
Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=508797