I am trying to get the title of my report to read the week end date for last week and exclude current week. I do not want to use relative dates incase there is an issue with data uploads. I would like to use a top 2 filter and exclude current week.
For instance, last week began March 17 and ended on March 23. I want the title to contain only the March 23 date. Is there a formula I can use to do this?