VBA code to filter on Specific two dates ( pivot table)

Hi, I am trying to Auto filter on a pivot table "dates" via VBA coding.

Sub test()

Sheet5.Pivottables("PivotTable5").PivotFields("Date Range").PivotFilters. _
        Add Type:=xlDateBetween, Value1:=Range("Startdaycomp"), Value2:=Range("FinishDaycomp")

End Sub

Where:
Startdaycomp = 11-May
Finishdaycomp = 18-May

Rather then this showing all values between these dates, I was hoping to see only those two dates. This will enable my to compare weekdays for a Dashboard.

Is this possible?

Thank you.

Regards,
Tejal S