Excel Formula

Question

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

lorenzo · Answer

Hi&nbsp;jonoross&nbsp;&nbsp;You seem to have an offset of 29 weeks since the begin. of the year&nbsp;&nbsp;in B3:=WEEKNUM(C3,2)-29

jonoross · Answer

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

lorenzo · Answer

jonoross&nbsp;&nbsp;2 things please:1/ As mentioned in Welcome to your Excel discussion space!-&nbsp;Your platform (Windows, Mac...)-&nbsp;Your Excel version&nbsp;2/ What week number do you expect after Dec 31, 2021?&nbsp;

jonoross · Answer

HeyaWeek 29 next year please 🙂I have a wondows Surface laptopI have the most recent Excel VersionThanks

lorenzo · Answer

jonoross&nbsp;Question was: What week number do you expect after Dec 31, 2021?You said: Week 29 next year please&nbsp;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?

Forum Discussion

Excel Formula

7 Replies

Resources