Earliest date using WEEKNUMBER

[Jock]

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,

 

[Mike H]

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]

Great stuff. Thanks Mike

 

[David Biddulph]

=IF(B2<>B1,A2-WEEKDAY(A2,3),"")