You need to have a good calendar table - that calendar should have a relationship in your data table to the relevant date, and then you can use columns from the calendar table for your reporting.
see @Melissa’s wonderful contribution to the community: