This content has been marked as final. Show 2 replies
Good morning people!
I need to compare the value of sales in 2015 and 2016 per week, but the comparison have to start on the first Monday of the year (in 2015 on 05/01 and 2016 on 04/01), because the day of the week has particularities in the business of my company.
In my attempt, the week begins on 01/01 in both years, which distorts the analysis
Do you know how I can determine when to begin my "Week 1", depending on the year?