Creating a record for every Friday in a month...

[MParker]

ok, so i'm stuck again and figured the experts here would find this to be easy, but it is just not coming to me.  so, i'm building a finance tracking database to track my bills for the month and basically, i'll have two tables.  one will be the payees table (which will have the payee name, amount due, date due, etc), and one table will be the list view of all the 'transactions' for the month.  essentially, at the beginning of the month, i want to click a button that will run a script to fill in all upcoming bills.  which works fine...until i got to one that needs to be paid every friday instead of once a month.  so, how can i calculate it to know to add a new record with the date of every friday in the month (4, sometimes 5 instances depending on the month).  is there an easy way to calculate that?

 

 

p.s. - if i posted this in the wrong forum, i'm sorry.  I wasn't sure where it should go.

[comment]

how can i calculate it to know to add a new record with the date of every friday in the month (4, sometimes 5 instances depending on the month).  is there an easy way to calculate that?

You only need to calculate the first Friday of the month, which is =

Let ( [
first = Get ( CurrentDate )  - Day ( Get ( CurrentDate ) ) + 1 
] ;
first + Mod ( 6 - DayofWeek ( first ) ; 7 )
)

Then loop and add 7 to the date until you roll over to the next month.

[MParker]

comment, you seem to be the person on this forum that always saves my day.  lol.  THANK YOU!