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

jonoross
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

Resources