Hi Sten

I should have added, Format cell as date in your preferred format.
Regards

Roger Govier


Roger Govier wrote:
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