Every scheduled report has a Reference date: the "as of" date its data is taken from, counted from the day the report is due. A report created from scratch starts on Yesterday. A duplicated report keeps the original report's reference date. For example, a report sent on a Monday with the reference date Yesterday shows Sunday's data. With End of last month, it shows the last day of the previous month.
The options are Today, Yesterday, End of last week, End of last month, End of last quarter, End of last year, and the "End of current" versions of week, month, quarter and year.
When you edit the report, the form shows Next delivery and Data as of under the schedule. In the email, each table and chart shows the dates its data covers.
The preview uses the same reference date as the next scheduled delivery. When the schedule sets the date, Content reference date shows it instead of a date picker when you edit the preview. Change it in the report's schedule settings.
Weeks run Monday to Sunday, so End of last week is the previous Sunday.
Manual reports don't have this setting. They use the Content reference date you set in Edit Preview, or the day you send them.

