Forum Discussion
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...
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
