From a previous discussion where I was kindly assisted by Tushar in resolving the answer to the subject line, I have since applied this to my view and noticed that it is displaying the data for the same DATE value last year and ideally, I could do with it displaying the same DAY last year. Today is Wednesday 28th March 2018 and I need the calc to return data for Wednesday 29th March 2017.
This was the resolution provided in my first discussion and I now wonder if anyone can assist in changing this for the desired outcome?
And I adapted it for use in my sheet as follows
I have attached some sample data 01/03/17 - 31/03/18
DAY (Receipt Date)= DAY(Dateadd('day',1, TODAY()))