Finance - historical for certain day of the week

I have a column with historical data for a certain ticker. I want to average only the Thursday data. I have it a very simple way right now just averaging every 5th row (entering each row number) but when there is a holiday it throws that off. Is there a formula that would solve this?