Set corresponding week numbers for dates

Occasional Visitor

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!

1 Reply


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.