Hi
I have to create VBA according to these criterias and I would be thankful if you can help:
I have a list of 22 rates that i need to distribute by order for a month period (30 days) noting that I need to skip weekends (Friday and Saturday)

Day 1 23.06.2014 Monday 20%
Day 2 24.06.2014 Tuesday 10%
Day 3 25.06.2014 Wednesday 7%
Day 4 26.06.2014 Thursday 4%
Day 5 27.06.2014 Friday
Day 6 28.06.2014 Saturday
Day 7 29.06.2014 Sunday 3%
Day 8 30.06.2014 Monday 2%
Day 9 01.07.2014 Tuesday 1%
Day 10 02.07.2014 Wednesday 1%
Day 11 03.07.2014 Thursday 2%
Day 12 04.07.2014 Friday
Day 13 05.07.2014 Saturday
Day 14 06.07.2014 Sunday 6%
Day 15 07.07.2014 Monday 8%
Day 16 08.07.2014 Tuesday 3.0%
Day 17 09.07.2014 Wednesday 1.0%
Day 18 10.07.2014 Thursday 2.0%
Day 19 11.07.2014 Friday
Day 20 12.07.2014 Saturday
Day 21 13.07.2014 Sunday 1.0%
Day 22 14.07.2014 Monday 1.0%
Day 23 15.07.2014 Tuesday 0.5%
Day 24 16.07.2014 Wednesday 0.5%
Day 25 17.07.2014 Thursday 0.5%
Day 26 18.07.2014 Friday
Day 27 19.07.2014 Saturday
Day 28 20.07.2014 Sunday 0.5%
Day 29 21.07.2014 Monday 0.5%
Day 30 22.07.2014 Tuesday 0.5%

Rates
20%
10%
7%
4%
3%
2%
1%
1%
2%
6%
8%
3.0%
1.0%
2.0%
1.0%
1.0%
0.5%
0.5%
0.5%
0.5%
0.5%
0.5%

I need help to create this formula so that each time I change the date the rates are distributes accordingly

Thank you
Best Regards
Lara