Convert Date in Iso week Number (vba)

[Helena26]

Hello Everyone,

I'm trying to change my Dates in specific columns automatically in Week Numbers. (K,L,M,X,Y,Z,etc.)

I know how to do it with typical excel operations but since I don't want to use another column for the output that's not the right way for me.

I tried to get my Problem sorted out with older Questions but I couldn't find something that helps me out.

Has anyone tried something like that befor and can help me ?

Thanks !

PS: Since I'm not a native speaker, don't get angry because of spelling mistakes but feel free to correct me.