Forum Discussion
Week starting Tuesday returns wrong week 53
Hi, I need to report in weeks running Tuesday - Monday. In this forum I have found a way to add a calculated column to do just that. All weeks number perfectly, but something goes wrong at the en...
Tropicaro Please provide the sample data (copiable format) to replicate your issue and also expected output as well.
Hi Pattemmanohar,
Sorry, only back at work now. I have added a link to a copy of the file.
The Coles Week runs from Tuesday to Monday. I am looking for a formula based on column [Sales Date], that would recreate the week numbers of column [Coles Week]
Thank you so much!