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:

Similarly, we can verify that the date **1/15/2023** is 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.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: Calculate the Number of Months Between Dates

Excel: How to Calculate Sum by Date

Excel: How to Calculate Average by Date