Forum Discussion

Rahma's avatar
Rahma
New Member
3 years ago
Solved

Week start day monday

Hello guys, I need to check if the day is a weekend or not, knowing that the week should starting with Monday. And to do it, i used weekday function. But the result is not correct. I have tried al...
Weekday
WEEKNUM
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Rahma,

    I check the system calendar and find the 1/7/2019 is Monday, the weekday function with option 2 in your table also get the correctly weekday number 1.(Monday to Sunday: 1~7) Why you say this function get the works with wrong result?

    IsWeekend =
IF ( WEEKDAY ( [Date], 2 ) > 5, 1, 0 )

    Regards,

    Xiaoxin Sheng

Rahma's avatar
Rahma
New Member
3 years ago

Anonymous i use september 2022 version

FreemanZ this is a screenshot for my dates table

jewel_at yes i created it, but the issue here is that saturday and sunday don't have the number 6 and 7 as expected. I added this column for my case 

IsWeekend = IF(WEEKDAY([Date],2) in { 1, 2} ,1,0)
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Rahma 

2019/1/1 is Tuesday, weekday of 2. What is the issue?