How to check if a date is on a weekend in Excel?

---

You can use the following formula in Excel to check if a given date is on a weekend:

=IF(OR(WEEKDAY(A2)={1,7}), "Weekend", "Not on Weekend")

This particular formula checks if the date in cell A2 is on a weekend or not and returns one of the following as a result:

• “Weekend”
• “Not on Weekend”

The following example shows how to use this formula in practice.

Example: How to Check if Date is on a Weekend in Excel

Suppose we have the following list of dates in Excel:

Suppose we would like to check if each date in column A is on a weekend or not.

We can type the following formula into cell B2 to do so:

=IF(OR(WEEKDAY(A2)={1,7}), "Weekend", "Not on Weekend") 

We can then click and drag this formula down to each remaining cell in column B:

Column B now tells us if each corresponding date in column A is on a weekend or not.

We can verify that the results are correct by manually checking a calendar.

For example, we can see that the date 1/3/2023 is indeed not on a weekend:

Note #1: We chose to return either “Weekend” or “Not a Weekend” as results from the IF function, but you can choose to return whatever values you would like.

Note #2: The WEEKDAY function returns a number between 1 and 7 to indicate the day of the week as a numeric value. Our formula checks if the function returns either a 1 or 7, which represent the weekend numeric values.