week No to date
 

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

week No to date
 

Hello Jon,

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

A1: Year
A2: Weeknum in year (ISO)

Regards,
Bernd

week No to date
 

Sorted Ta

"Bernd P" wrote:

Hello Jon,

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

A1: Year
A2: Weeknum in year (ISO)

Regards,
Bernd
.