Hi Mary

I'm sorry, I meant to make the base of 1 = Monday for Weekday.
Change the formula to
=IF(WEEKDAY(A2,2)<6,"Y","")


--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi Mary

Add an extra column to your source data, titled Weekday
In this column enter
=IF(WEEKDAY(A2)<6,"Y","")
Change A2 to the column containing your dates and copy down

Extend the data range in your PT to include this extra column.
Drag the Weekday field to the Page area and from the dropdown Select Y

--
Regards

Roger Govier


"maryj" wrote in message
...
The data has a field called "Date". In the pivot table, the grouping
is set
to display the dates in 3 day groups. Is there any way to do this
type of
grouping but only use the weekdays and exclude the weekends?
--
maryj