formula/macro. How to convert data (weekday, week number, year) to a date?

Hi all
I need bit help as all my own attempts to find/create a solution have been unfruitful.

I have data in three columns (col A,B,C - weekday, week number and year). Can anyone help me to figure out a formula or macro solution to convert all this into a date (in UK format - dd/mm/yyyy). Please see example below:

Before

Col A ----------- Col B -------- Col C
Tuesday --------- 43 --------- 2011
Monday ---------- 44 --------- 2011
Tuesday --------- 44 --------- 2011
Wednesday ---- 44 --------- 2011
Monday ---------- 45 --------- 2011
Tuesday --------- 45 --------- 2011
Tuesday --------- 45 --------- 2011
Wednesday ---- 45 --------- 2011
Thursday -------- 45 --------- 2011



After

Col A ----------- Col B -------- Col C --------- Col D
Tuesday --------- 43 --------- 2011 --------- 25/10/2011
Monday ---------- 44 --------- 2011 --------- 31/10/2011
Tuesday --------- 44 --------- 2011 --------- 01/11/2011
Wednesday ---- 44 --------- 2011 --------- 02/11/2011
Monday ---------- 45 --------- 2011 --------- 07/11/2011
Tuesday --------- 45 --------- 2011 --------- 08/11/2011
Tuesday --------- 45 --------- 2011 --------- 08/11/2011
Wednesday ---- 45 --------- 2011 --------- 09/11/2011
Thursday -------- 45 --------- 2011 --------- 10/11/2011



I have attached a spreadsheet with this very same example. Any help is greatly appreciated.
Cheers

For ISO week numbers try this formula in D1 copied down

=DATE(C1,1,-3)-WEEKDAY(DATE(C1,1,3))+B1*7+MATCH(A1,INDEX(TEXT(ROW(INDIRECT("2:8")),"dddd"),0),0)