How to determine if a date falls on the weekend?

Question

Given a date as input, how can I determine whether the day falls on a weekend?

Admin · Answer

Or, you can use this:

OR(MOD(WEEKDAY(cell), 7)=0, MOD(WEEKDAY(cell), 7)=1)

or

MOD(WEEKDAY(cell), 7) < 2

as a formula.

since 1 is Sunday and 0 is Saturday