Date from one cell to weeknum to another cell

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3168156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EDate%20from%20one%20cell%20to%20weeknum%20to%20another%20cell%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3168156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20automate%20the%20following%3A%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348379iC12D5C016FCC2E10%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Screenshot%202022-02-15%20163012.png%22%202022-02-15%3D%22%22%20163012.png%3D%22%22%20alt%3D%22Screenshot%202022-02-15%20163012.png%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat%20the%20weeknumbers%20will%20be%20put%20on%20the%20right%20(Collumn%20F)%20and%20get%20the%20data%20from%20(Collumn%20E)%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAnd%20if%20there%20is%20no%20text%20at%20Collumn%20E%2C%20there%20will%20be%20no%20text%20at%20Collumn%20F%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3168156%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3168179%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20from%20one%20cell%20to%20weeknum%20to%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3168179%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1306410%22%20target%3D%22_blank%22%3E%40GKE2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(E2%26lt%3B%26gt%3B%22%22%2CISOWEEKNUM(E2)%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20formula%20which%20works%20in%20my%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

Is it possible to automate the following:?

Screenshot 2022-02-15 163012.png

That the weeknumbers will be put on the right (Collumn F) and get the data from (Collumn E)?

And if there is no text at Collumn E, there will be no text at Collumn F?

2 Replies

@GKE2019 

=IF(E2<>"",ISOWEEKNUM(E2),"")

Maybe with this formula which works in my spreadsheet. 

When I put it in there I get an Error