Jock,

With your list of dates in column A and the corresponding wee numbers in
column B put this in C1

=DATE(YEAR(A1),1,B1*7-(DAY(DATE(YEAR(A1),1,1)+7-WEEKDAY(DATE(YEAR(A1),1,1),1))))

Then put this in C2 and drag down
=IF(B2=B1,"",DATE(YEAR(A2),1,B2*7-(DAY(DATE(YEAR(A2),1,1)+7-WEEKDAY(DATE(YEAR(A2),1,1),1)))))

Mike

"Jock" wrote:

Hi,
Dates in column A and WEEKNUMBER in cloumn B (referring to A).
How do I display (in C) only the earliest date (without duplicates) for each
week (Ie the Monday's date)

Thanks,
--
Traa Dy Liooar

Jock