Discussion Locked

Calculate Day of week

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

3 replies

by dklippert

If you'll post your formula we could be more specific, but the function:

=WEEKDAY(serial_number,return_type)

might work.
Serial_number is the date
Return_type 1 returns 1=Sunday etc.
Return_type 2 returns 1=Monday etc.
Return_type 3 returns 0=Monday etc.

This discussion is closed to new replies.