Forum Discussion
Pivot Table
Hi there, I have an interesting challenge, I have a spreadsheet with 53,000(ish) rows with 25 columns of data. I have a date column; with data entered each week and when I create a pivot table t...
Add a column to your data, and use the WEEKNUM function to convert the full date from your date column into a week number (it does it for whatever week it is out of the 52 weeks in the year). Your pivot table would use that WEEKNUM column to display the results you're looking for.