week No to date

[Jon]

Hi
I have some data with the date reprisented by a week No
I want to make a date on the Monday of that week in a seperate colum any
advise please

 

[Bernd P]

Hello Jon,

As given by some guy called daddylonglegs:
[citation from
http://www.excelforum.com/excel-gen...ng-data-from-week-number-reverse-weeknum.html
]
=DATE(A1,1,A2*7-2)-WEEKDAY(DATE(A1,1,3))

A1: Year
A2: Weeknum in year (ISO)

Regards,
Bernd

 

[Jon]

Sorted Ta