MARCO help!

[pleasehelpmeexcelpro]

Hi,

I am trying to create a marco for updating number based on day of the week....

Sunday = 0.1
Monday = 1.1
Tuesday =2.1
Wednesday = 3.1
Thursday = 4.1
Friday = 5.1
Saturday = 5.5

 

[Joe4]

I am afraid we are going to need a bit more detail.
Where is this value you need updated?
Is it just one value, or many?
Is there anything else in the cells you need to look at other than the day of the week name?
Do you want it changed in that same cell, or just a cell next to it updated?