General discussion

Locked

Calculate Day of week

By homekey1 ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Calculate Day of week

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.

Collapse -

by homekey1 In reply to

Poster rated this answer.

Collapse -

by homekey1 In reply to Calculate Day of week

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums