Hi All,
Right now in the attached workbook, I use cell B1 for my current week (YY-Week#) and it will update the last cell. However I have to remember to add a column and adjust a specific cell to be -49 (in this example, cell BD1). Since there are only 52 weeks it has to cap at 52 before moving out to 1601, 1701 etc.
Would really appreciate someones eye's on this. Thanks!
This is a more complicated formula but the nice thing about it is that it is exactly the same formula in every cell.
=MOD((COLUMN()-COLUMN($E$1)),52)+1+100*(15+INT((COLUMN()-COLUMN($E$1))/52))
Note that $E$1 is the first column that you are using, and 15 is the number of the first year you want to use. So it can be easily updated to change position or year. (It doesn't matter what row you put it in.)
With E1= 1501
in F1
=IF(MOD(E2,100)=52,E2+49,E2+1)
Drag across
Or in BW1
and copy to left
Please Login or Register to view this content.
Kind regards
Or maybe this
My startpoint is 1-1-2015 and not the week of today (Year 2016 and weeknumber 20)
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks