Date Formula Help

Ask for Help
1

  • 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
image700×586 30.2 KB

2

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

3

Here is a loom 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.

4

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

5

yes

6

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