This content has been marked as final. Show 4 replies
Hi, QV community
I have one problem that needs solving.
I have data for the sale of my company for every day.
I wanted to make a big text box that says "Sales in & last(YrWk)
But my problem is of course that the date is always changing so I have to make a formula in my text box
Let me explain this better:
So today is the date 5.11.2015 so that makes it week 45 in the year 2015 or 2015-Wk45 in my data.
So last week was 2015-Wk44.
So I need a formula in the text box that says Sales in 2015-Wk44