Excel Formula

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