Determine If a Date Falls on the Weekend

This post will guide you how to determine if a date falls on the weekend in Excel. How do I check if a date falls on the weekend with a formula in Excel. How to check if a date is a weekend in Excel.

Check if a Date Falls on the Weekend

Assuming that you have a list of data that contain dates in range A1:A5, and you want to check each date if it falls on the weekend. How to achieve it. You can create a formula based on the IF function, the OR function and the WEEKDAY function. Just like this:

=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),TRUE,FALSE)

Type this formula into Cell B1, and press Enter key in your keyboard, and then drag the AutoFill Handle from Cell B1 to B5.

This formula will check if a date falls on the weekend, it will return TRUE, otherwise, it will return FALSE.

Related Functions

• Excel IF function
  The Excel IF function perform a logical test to return one value if the condition is TRUE and return another value if the condition is FALSE. The IF function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.The syntax of the IF function is as below:= IF (condition, [true_value], [false_value])….
• Excel WEEKDAY function
  The Excel WEEKDAY function returns a integer value representing the day fo the week for a given Excel date and the value is range from 1 to 7.The syntax of the WEEKDAY function is as below:=WEEKDAY (serial_number,[return_type])…
• Excel OR Function
  The Excel OR function used to test multiple conditions and returns TRUE if any of the conditions are TRUE.The syntax of the OR function is as below:=OR(logical1, [logical2], …)…