Hi Maryj,

Yes, you can definitely group your pivot table data by weekdays and exclude weekends. Here's how you can do it:

1. Select the column that contains the dates in your pivot table.
2. Right-click on the selected column and choose "Group" from the context menu.
3. In the "Grouping" dialog box, select "Days" from the "By" options.
4. In the "Number of days" field, enter "7" to group the dates by week.
5. In the "Starting at" field, enter the date of the first weekday you want to include in the grouping. For example, if you want to exclude weekends and start with Monday, enter the date of the first Monday in your data.
6. In the "Ending at" field, enter the date of the last weekday you want to include in the grouping. For example, if you want to exclude weekends and end with Friday, enter the date of the last Friday in your data.
7. Click "OK" to apply the grouping.

Your pivot table will now display the data grouped by weekdays, excluding weekends. If you want to adjust the grouping further, you can always go back to the "Grouping" dialog box and make changes.