Creating Dates / Week Ending

Hi Everyone,
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

Hello @ConstantD,

I would take following approach:

From experience week numbers produced by above steps don’t have to match your week numbers so building your own file manually (or semi-manually) might be better option.


1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.