Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2558500%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2558500%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20anyone%20happen%20to%20know%20the%20formula%20to%20make%20the%20below%20a%20sequence%20instead%20of%20me%20typing%20the%20numbers%20in%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jonoross_0-1626523472518.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296564i979DB4E714CF6316%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jonoross_0-1626523472518.png%22%20alt%3D%22jonoross_0-1626523472518.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2558500%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2558537%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2558537%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1102841%22%20target%3D%22_blank%22%3E%40jonoross%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20seem%20to%20have%20an%20offset%20of%2029%20weeks%20since%20the%20begin.%20of%20the%20year%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Demo.png%22%20style%3D%22width%3A%20219px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296566iA620DC8A7C0A595F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Demo.png%22%20alt%3D%22Demo.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20B3%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DWEEKNUM(C3%2C2)-29%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2558585%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2558585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1102841%22%20target%3D%22_blank%22%3E%40jonoross%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2%20things%20please%3A%3CBR%20%2F%3E1%2F%20As%20mentioned%20in%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E-%26nbsp%3BYour%20platform%20(Windows%2C%20Mac...)%3C%2FP%3E%3CP%3E-%26nbsp%3BYour%20Excel%20version%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2%2F%20What%20week%20number%20do%20you%20expect%20after%20Dec%2031%2C%202021%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi guys

 

Would anyone happen to know the formula to make the below a sequence instead of me typing the numbers in? 

 

jonoross_0-1626523472518.png

 

7 Replies

Hi @jonoross 

 

You seem to have an offset of 29 weeks since the begin. of the year

 

Demo.png

 

in B3:

=WEEKNUM(C3,2)-29
Thanks heaps! Do you know how to make it carry over into the new year?

@jonoross 

 

2 things please:
1/ As mentioned in Welcome to your Excel discussion space!

- Your platform (Windows, Mac...)

- Your Excel version

 

2/ What week number do you expect after Dec 31, 2021?

 

Heya

Week 29 next year please

I have a wondows Surface laptop
I have the most recent Excel Version

Thanks

@jonoross 

Question was: What week number do you expect after Dec 31, 2021?
You said: Week 29 next year please

 

According to your current offset by 29 weeks, last weeknum in Dec 2021 is #24. Logically 1st weeknum in calendar year 2022 should be 25. Assuming you really want 29 instead, could you give the date (mm/dd/yyyy) where weeknum should = 1 in your 2022 calendar?

Heya

The weeks will be ongoing. Is there anyway to make it unlimited weeks?

Thanks

@jonoross 

Perhaps you mean something like this

image.png