Table of Contents
The function “Is the date on a weekend” in Excel is designed to determine whether a specific date falls on a weekend, specifically a Saturday or Sunday. This function is useful for organizing and analyzing data that may be affected by weekend dates, such as work schedules or business operations. It returns a Boolean value of either “True” or “False” based on the input date, making it a simple and efficient way to identify weekend dates within a given data set.
Check if 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.
Additional Resources
The following tutorials explain how to perform other common operations in Excel: