Calculate Day of week

Does anyone know of a way to quickly select a particular day of the week in a spreadsheet? example, select every Sunday. I need to exclude Sundays from my formulas, but I need to show them in the spreadsheet.