# Date Formula Help

**URL:** <https://community.glideapps.com/t/date-formula-help/69621>\
**Category:** Ask for Help\
**Created:** [January 16, 2024, 6:19pm UTC](https://community.glideapps.com/t/date-formula-help/69621 "2024-01-16T18:19:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![John\_Romano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_romano/32/74316_2.png) [@John\_Romano](https://community.glideapps.com/u/John_Romano)\
**Post date:** [January 16, 2024, 6:19pm UTC](https://community.glideapps.com/t/date-formula-help/69621/1 "2024-01-16T18:19:54Z")

</div>

- I have a column that is named “DUE DATE” for bills that are due

- We get paid on a monday

- So if a bill’s “DUE DATE” falls on or before a Monday Pay Date, not going to the following Monday paydate of course

- I need a formula column that looks at that “DUE DATE” and says the correct payday

example: Paydate was 1/15/2024 - I need the comuted “PAY DATE” column for all the bills that have a duedate of 9th(Tuesday) thru 15th(Monday) to be on the 15th. So on…

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a11e558f30825463366b31beac0bca059437396.jpeg)

---

<div class="post-metadata">

**Author:** ![John\_Romano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_romano/32/74316_2.png) [@John\_Romano](https://community.glideapps.com/u/John_Romano)\
**Post date:** [January 16, 2024, 7:06pm UTC](https://community.glideapps.com/t/date-formula-help/69621/2 "2024-01-16T19:06:03Z")

</div>

@ThinhDinh @Darren_Murphy need help on this one please : - ) Chat GPT cant

---

<div class="post-metadata">

**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\
**Post date:** [January 16, 2024, 9:08pm UTC](https://community.glideapps.com/t/date-formula-help/69621/3 "2024-01-16T21:08:32Z")

</div>

Here is a [loom](https://www.loom.com/share/e763ec1ae22244529c53a975ae3b03f1) that may help get you started without doing anything too fancy. This uses a second table using the query column to bring in bills that fall within the date range.

Again, not a full solution but might get you started.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 16, 2024, 11:47pm UTC](https://community.glideapps.com/t/date-formula-help/69621/4 "2024-01-16T23:47:59Z")

</div>

So do you always have your pay dates as Monday weekly?

---

<div class="post-metadata">

**Author:** ![John\_Romano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_romano/32/74316_2.png) [@John\_Romano](https://community.glideapps.com/u/John_Romano)\
**Post date:** [January 17, 2024, 12:49pm UTC](https://community.glideapps.com/t/date-formula-help/69621/5 "2024-01-17T12:49:44Z")

</div>

yes

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 17, 2024, 1:48pm UTC](https://community.glideapps.com/t/date-formula-help/69621/6 "2024-01-17T13:48:10Z")

</div>

So anything from this Tuesday until next Monday is counted in one “cycle”?