Formula to calculate date from, weekday-weeknumber-year

Hi Guys
I used to have this formula before but I have lost it. I tried to find my old thread but everything is wiped. No help from Google as well.

Anyway could someone help me out.
I have data as follows: weekday, weeknumber, year (col A, B and C respectively). using this data I would like to have a formula to populate the dates to col D


Example (before):

Weekday ----- Weeknumber ----- Year ----- Date

Monday ------------ 1 ---------- 2012 -----
Tuesday ----------- 1 ---------- 2012 -----
Wednesday -------- 1 ---------- 2012 -----
Thursday ---------- 1 ---------- 2012 -----
Friday ------------- 1 ---------- 2012 -----
Saturday ---------- 1 ---------- 2012 -----
Sunday ------------ 1 ---------- 2012 -----
Monday ------------ 2 ---------- 2012 -----
Tuesday ----------- 2 ---------- 2012 -----
Wednesday -------- 2 ---------- 2012 -----
Thursday ---------- 2 ---------- 2012 -----
Friday ------------- 2 ---------- 2012 -----
Saturday ---------- 2 ---------- 2012 -----
Sunday ------------ 2 ---------- 2012 -----
Monday ------------ 3 ---------- 2012 -----
Tuesday ----------- 3 ---------- 2012 -----
Wednesday -------- 3 ---------- 2012 -----
Thursday ---------- 3 ---------- 2012 -----
Friday ------------- 3 ---------- 2012 -----
Saturday ---------- 3 ---------- 2012 -----
Sunday ------------ 3 ---------- 2012 -----


Example (after):

Weekday ----- Weeknumber ----- Year ----- Date

Monday ------------ 1 ---------- 2012 ----- 02/01/2012
Tuesday ----------- 1 ---------- 2012 ----- 03/01/2012
Wednesday -------- 1 ---------- 2012 ----- 04/01/2012
Thursday ---------- 1 ---------- 2012 ----- 05/01/2012
Friday ------------- 1 ---------- 2012 ----- 06/01/2012
Saturday ---------- 1 ---------- 2012 ----- 07/01/2012
Sunday ------------ 1 ---------- 2012 ----- 08/01/2012
Monday ------------ 2 ---------- 2012 ----- 09/01/2012
Tuesday ----------- 2 ---------- 2012 ----- 10/01/2012
Wednesday -------- 2 ---------- 2012 ----- 11/01/2012
Thursday ---------- 2 ---------- 2012 ----- 12/01/2012
Friday ------------- 2 ---------- 2012 ----- 13/01/2012
Saturday ---------- 2 ---------- 2012 ----- 14/01/2012
Sunday ------------ 2 ---------- 2012 ----- 15/01/2012
Monday ------------ 3 ---------- 2012 ----- 16/01/2012
Tuesday ----------- 3 ---------- 2012 ----- 17/01/2012
Wednesday -------- 3 ---------- 2012 ----- 18/01/2012
Thursday ---------- 3 ---------- 2012 ----- 19/01/2012
Friday ------------- 3 ---------- 2012 ----- 20/01/2012
Saturday ---------- 3 ---------- 2012 ----- 21/01/2012
Sunday ------------ 3 ---------- 2012 ----- 22/01/2012


Unfortunately I can not attach a spreadsheet to the post as I can not do any uploads from my workplace PC.
Any help is much appreciated.
Cheers

Hi rain4u,

If you have the data in order you have shown here, you can simply put one date at starting and drag it down till end.

Regards,
DILIPandey

<click on below 'star' if this helps>

the first monday in weeknumber 1 in year 2012 according to the ISO criteria:

PHP Code: 

=DATE(2012,1,4)-WEEKDAY(DATE(2012,1,4),2)+1 


you can fill column D:

Please Login or Register  to view this content.

Try this, it uses the week commencing the first Monday in January as week 1

Please Login or Register  to view this content.

Select from the dropdowns in A2:C2 to see the results