My spreadsheet has sample data of grouped by month, grouped by Day. I would like the same date displayed for the group by the past 7 days. When...

The group by ((DATEDIFF(day, getdate(), "datefield"))/7) solution.

This looks like the correct logic but it is in integer format. Is there a way for me to get the date of this calculation? For example display...

Yes I did.

Thank you both for your responses. I was able to educate myself a little more about the sp_executesql and it is now behaving as I need it to.

I have over 100 columns that I am summing up. I have exceeded the 4000 characters for my first @sql which is why I have a @sql and @SQL1....