Forum Discussion
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 - e...
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.