Forum Discussion
catcmos
Aug 05, 2022Copper Contributor
Set corresponding week numbers for dates
I'm trying to improve the functionality of a spreadsheet tracking orders at my workplace. I want to create an autofill feature for week numbers in the column next to the date the order was placed - each week of the year (starting sunday and ending saturday) is numbered 1-52, starting at the first week of February. I know this can be done, because someone has put this in place for the weeks our orders realise on - the column next to delivery date auto fills with the associated week. I just for the life of my can't figure out how they've done it! I haven't used excel since 2015 and honestly don't know where to start. Any help is very welcome, and if you need more information just let me know!
If the week number column does not contain formulas, right-click the sheet tab and select 'View Code' from the context menu. You'll probably see some VBA code - this should automatically fill the week number when the delivery date is entered.