# Excel Formula

Occasional Contributor

# Excel Formula

Hi guys

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

7 Replies

# Re: Excel Formula

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

in B3:

``=WEEKNUM(C3,2)-29``

# Re: Excel Formula

Thanks heaps! Do you know how to make it carry over into the new year?

# Re: Excel Formula

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?

# Re: Excel Formula

Heya

Week 29 next year please

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

Thanks

# Re: Excel Formula

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?

# Re: Excel Formula

Heya

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

Thanks

# Re: Excel Formula

Perhaps you mean something like this