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!
