Excel Guides

How to Specify Different Weekends in Excel

There are a few different ways that you can specify different weekends in Excel. One way is to use the WEEKDAY function. This function takes a date and returns a number between 1 and 7, where 1 is Sunday and 7 is Saturday. You can use this function to specify which days are weekend days and which are weekdays.

Another way to specify different weekends in Excel is to use the WORKDAY function. This function takes a date and returns the next workday. You can use this function to skip over weekends when you are calculating workdays.

You can also use the DAY function to specify different weekends in Excel. This function returns the day of the week for a given date. You can use this function to find out which days are weekend days.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.