I have a large amount of data that i need to find the trend for.

Unfortunately the trend has to be based on the first saturday, first moday first tuesday.... 5th friday.

So i need to be able to do the trend of the past year's first saturdays, first mondays, 2nd mondays etc.

any ideas?