Hi! I am trying to create a base for upcoming, recurring bills. Currently I have a base that I have to manually adjust the due date for each bill every month. This also creates a problem where there is no record of the previous bills paid.

I’m trying to set up an automation within airtable and possibly zapier that essentially auto creates a new bill record two weeks prior to the bill’s due date, and the due date cell is auto created for the future bill (which will be the same day every month).

Can anyone help?