You might want to do the formula as year(a1)&right("0"&weeknum(a1),2)
which will give you a result that is always six digits.