Forum Discussion

Copper Contributor

Jul 17, 2021

Excel Formula

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

Silver Contributor

Jul 17, 2021

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

in B3:

=WEEKNUM(C3,2)-29

Copper Contributor

Jul 17, 2021

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

Lorenzo
Silver Contributor
Jul 17, 2021
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?
- jonoross
  Copper Contributor
  Jul 18, 2021
  Heya
  
  Week 29 next year please 🙂
  
  I have a wondows Surface laptop
  I have the most recent Excel Version
  
  Thanks
  - Lorenzo
    Silver Contributor
    Jul 19, 2021
    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?

Resources