Thread: week No to date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default 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