My work is to set a sell through file. In which I show the sales by reference of products, their stock. This file is on a weekly basis.
I would like to know how I can add on my workflow a column in which I put the week ending (the date of the final day of a week)?
In addition, I would like this date to be automatized whenever I change the excel reader. exemple : if I want to put the sales from week 44, I would like to have put in week ending 01/11/2020