# Week Day, Saturday or Sunday

**URL:** <https://forums.knack.com/t/week-day-saturday-or-sunday/20097>\
**Category:** Next-Gen\
**Created:** [December 17, 2025, 2:16pm UTC](https://forums.knack.com/t/week-day-saturday-or-sunday/20097 "2025-12-17T14:16:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![houwtama](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/houwtama/32/5235_2.png) [@houwtama](https://forums.knack.com/u/houwtama)\
**Post date:** [December 17, 2025, 2:16pm UTC](https://forums.knack.com/t/week-day-saturday-or-sunday/20097/1 "2025-12-17T14:16:28Z")

</div>

I’m using the script as below in a formula field to determine if a date falls on a week day, a Saturday or Sunday.

({Day}\>1 & {Day}\<7)? 1 : {Day}=7? 2 : 3

Doesn’t work and I don’t know why…

Any help much appreciated.

---

<div class="post-metadata">

**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\
**Post date:** [December 17, 2025, 8:34pm UTC](https://forums.knack.com/t/week-day-saturday-or-sunday/20097/2 "2025-12-17T20:34:14Z")

</div>

> [@houwtama](#):
>
> ({Day}\>1 & {Day}\<7)? 1 : {Day}=7? 2 : 3

Hi @houwtama

Try This:

({Day}\>1 & {Day}\<7)? 1 : {Day}==7? 2 : 3

In Knack if you are equating 2 things you need a ==

Craig

---

<div class="post-metadata">

**Author:** ![houwtama](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/houwtama/32/5235_2.png) [@houwtama](https://forums.knack.com/u/houwtama)\
**Post date:** [December 18, 2025, 7:58am UTC](https://forums.knack.com/t/week-day-saturday-or-sunday/20097/3 "2025-12-18T07:58:53Z")

</div>

Thanks a million @CSWinnall !!! 😀 🙏