Jul 17 2021 05:05 AM
Hi guys
Would anyone happen to know the formula to make the below a sequence instead of me typing the numbers in?
Jul 17 2021 05:24 AM
Hi @jonoross
You seem to have an offset of 29 weeks since the begin. of the year
in B3:
=WEEKNUM(C3,2)-29
Jul 17 2021 05:36 AM
Jul 17 2021 06:05 AM
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?
Jul 18 2021 12:51 PM
Jul 18 2021 09:50 PM
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?
Jul 19 2021 12:05 PM
Jul 19 2021 12:37 PM