{"id":2092,"date":"2022-10-28T13:01:13","date_gmt":"2022-10-28T13:01:13","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=2092"},"modified":"2022-11-14T18:54:55","modified_gmt":"2022-11-14T18:54:55","slug":"valt-een-datum-in-het-weekend","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/10\/28\/falls-a-date-on-the-weekend\/","title":{"rendered":"Does a date fall on a weekend?"},"content":{"rendered":"

In this article, I'll explain how you can find out if a date falls on a weekend or not. For this we use a simple formula.<\/p>\n\n\n\n

For convenience, you can use the sample file. This can be downloaded at the bottom of this page<\/a>.<\/p>\n\n\n\n

The formula<\/h2>\n\n\n\n

To find out whether a date falls on a weekend, we use the formula\/function below. <\/p>\n\n\n\n

WEEKDAY(serial_number;[type_number])<\/code><\/pre>\n\n\n\n
The function is structured as follows with the following arguments:<\/p>\n\n\n\n
    \n
  • serial number<\/strong>. This argument is required and must be a serial number. A date in a cell that is formatted as text therefore does not work. You will first have to convert this to a date format. A date that is formatted as a date is seen in Excel as a serial number and therefore works.<\/li>\n\n\n\n
  • type_number<\/strong>. This argument is optional and determines the result. With this argument you can indicate what the first day of the week is.<\/li>\n<\/ul>\n\n\n\n
    Results WEEKDAY()<\/h3>\n
    \n    \n    \n\n    \n        \n        \n        \n\n\n                    wdt_ID<\/th>        type_result<\/th>        Result<\/th>    <\/tr>\n<\/thead>\n        \n\n        \n        \n\n            \n                            \n                            \n                            \n                            \n                            \n                            \n                            \n                            \n                            \n                            
    1<\/td>\n                            1<\/td>\n                            \t A number from 1 (Sunday) to 7 (Saturday). This corresponds to previous versions of Microsoft Excel.<\/td>\n                    <\/tr>\n                
    2<\/td>\n                            2<\/td>\n                            A number from 1 (Monday) to 7 (Sunday).<\/td>\n                    <\/tr>\n                
    3<\/td>\n                            3<\/td>\n                            A number from 0 (Monday) to 6 (Sunday).<\/td>\n                    <\/tr>\n                
    4<\/td>\n                            11<\/td>\n                            A number from 1 (Monday) to 7 (Sunday).<\/td>\n                    <\/tr>\n                
    5<\/td>\n                            12<\/td>\n                            A number from 1 (Tuesday) to 7 (Monday).<\/td>\n                    <\/tr>\n                
    6<\/td>\n                            13<\/td>\n                            A number from 1 (Wednesday) to 7 (Tuesday).<\/td>\n                    <\/tr>\n                
    7<\/td>\n                            14<\/td>\n                            A number from 1 (Thurs) to 7 (Wednesday).<\/td>\n                    <\/tr>\n                
    8<\/td>\n                            15<\/td>\n                            A number from 1 (Friday) to 7 (Thursday).<\/td>\n                    <\/tr>\n                
    9<\/td>\n                            16<\/td>\n                            A number from 1 (Saturday) to 7 (Friday).<\/td>\n                    <\/tr>\n                
    10<\/td>\n                            17<\/td>\n                            A number from 1 (Sunday) to 7 (Saturday).<\/td>\n                    <\/tr>\n    <\/tbody>        \n\n        \n        \n        \n    <\/table>\n\n<\/div>