Excel 2000 data question

I have daily data for the DJIA going back to inception. Is there a formula that can help me pick weekly/monthly/yearly closes without having to individually select the data points?

tks in advance.