Hi, could use some help.
I have a spreadsheet with a list of items and a date in column 2.
I need to look at the date and determine the week that it falls under then place the date for Monday into Column 1.
I would appreciate any ideas on how to tackle this. Inserting an excel formula using VBA might be an option because I would need to input the column and row index into the formula in a for each process.