Hi Sten

One way
=DATE(2000+LEFT(A1,2),1,1)+MID(A1,3,2)*7+RIGHT(A1)

Regards

Roger Govier


converting 05445 to 2005-10-04 wrote:
Hi,
Could someone pls help me with finding a good way of converting
05445 to 2005-10-04 ?
i.e. converting a date in the format of year+week+daynr to
year-month-day.

thank you,

Sten