I recorded a macro that would filter the dates in column A between two
dates. I looked at the code and made some edits and came up with this after
a little bit of tweaking:

Sub ChangeWeek()

Dim weekbegin As Date
Dim weekend As Date

weekbegin = InputBox("Week Beginning")
weekend = InputBox("Week Ending")
Selection.AutoFilter Field:=1, Criteria1:=weekbegin, Operator:=xlOr _
, Criteria2:=weekend

End Sub

Only problem is that the code above only shows me those 2 dates. I need the
dates in between too.

I know its something simple, but I cant figure it out. Any help would be
cool.

Thanks
Niq