How to determine the weekend using the WEEKDAY Function
A quick and easy way of figuring out which dates fall on the weekend is by using the WEEKDAY Function in Excel. Another way to tackle this is to use the method explained in our previous article that can be found HERE. The WEEKDAY function returns the day of the week as a number corresponding to a date. The returned number is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. Here is how we’ll apply it in a formula.
How to use the WEEKDAY Function to determine the weekend
- Enter your dates in Column A and enter the following formula in B1: =IF(OR(WEEKDAY(A1)=7,WEEKDAY (A1)=1),”weekend”,”").
- Copy the formula using the fill handle as needed.
You should now see the word ‘weekend’ displayed whenever the date in question falls on a weekend. This tip should work in Excel 97, 2000, 2003 and 2007.
- How to calculate the weeks of Advent using Excel’s Weekday Function
- How to Use the WEEKNUM function to determine the week number
- How to check for future dates using TODAY Function in Excel
- Use the NETWORKDAYS function to determine number of workdays
- How to use the TEXT function to extract parts of a date in Excel
