# Formula - payment term and due date **URL:** \ **Category:** Baserow Help\ **Tags:** formula\ **Created:** [July 10, 2026, 11:11am UTC](https://community.baserow.io/t/formula-payment-term-and-due-date/12651 "2026-07-10T11:11:17Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Alahrikk](https://community.baserow.io/letter_avatar_proxy/v4/letter/a/bb73d2/32.png) [@Alahrikk](https://community.baserow.io/u/Alahrikk)\ **Post date:** [July 10, 2026, 11:11am UTC](https://community.baserow.io/t/formula-payment-term-and-due-date/12651/1 "2026-07-10T11:11:17Z")
### 🤖 Kuma (Baserow’s AI assistant): often the fastest way to get help. Try asking Kuma before posting here. Available to all SaaS users, and to self-hosted users with a connected AI model. on ### Are you using our SaaS platform ([Baserow.io](http://Baserow.io)) or self-hosting Baserow? SaaS ### What do you need help with? Hello, I would like to find out the due date for my invoice, based on the payment term. When I need to add a certain number of days to the due date, that’s not a problem. How can I work out the correct due date when the payment term is XX days to the end of the month? I can’t seem to find the right formula to display the last day of the month after adding 30 days to the due date. Thank you for your support. ---
**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\ **Post date:** [July 10, 2026, 3:40pm UTC](https://community.baserow.io/t/formula-payment-term-and-due-date/12651/2 "2026-07-10T15:40:50Z")
Hey @Alahrikk, I could only come up with something like this: ![image](https://community.baserow.io/uploads/default/original/2X/5/5fc3c85611403385bfbc671ab43fbef831d880d2.png) Using this formula: `if(field('Payment Term') = '30 days', field('Invoice Date') + date_interval('30 days'), if(field('Payment Term') = '14 days', field('Invoice Date') + date_interval('14 days'), field('Invoice Date')))` Is it what you’re looking for? ---
**Author:** ![Alahrikk](https://community.baserow.io/letter_avatar_proxy/v4/letter/a/bb73d2/32.png) [@Alahrikk](https://community.baserow.io/u/Alahrikk)\ **Post date:** [July 11, 2026, 7:15am UTC](https://community.baserow.io/t/formula-payment-term-and-due-date/12651/4 "2026-07-11T07:15:34Z")
Thank you for your feedback. That’s not exactly what I need. Some of the payment terms I use define the payment date as the last day of the month. This is calculated by adding 30 days to the invoice send date and setting the last day of the month. So, I am wondering whether Baserow could help by showing the correct payment date using this method. ---
**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\ **Post date:** [July 13, 2026, 9:02am UTC](https://community.baserow.io/t/formula-payment-term-and-due-date/12651/5 "2026-07-13T09:02:59Z")
We don’t have `end_of_month()` or `last_day()` functions, so it’s not straightforward. Let me check with the team if we plan to add these functions 🙂 ---
**Author:** ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)\ **Post date:** [October 16, 2026, 11:46am UTC](https://community.baserow.io/t/formula-payment-term-and-due-date/12651/6 "2026-10-16T11:46:58Z")
Hey @Alahrikk, here’s the issue for adding this function: [Add formula functions to get the last day of a month · Issue #6399 · baserow/baserow · GitHub](https://github.com/baserow/baserow/issues/6399) 🙂 ---
**Author:** ![Alahrikk](https://community.baserow.io/letter_avatar_proxy/v4/letter/a/bb73d2/32.png) [@Alahrikk](https://community.baserow.io/u/Alahrikk)\ **Post date:** [October 16, 2026, 12:22pm UTC](https://community.baserow.io/t/formula-payment-term-and-due-date/12651/7 "2026-10-16T12:22:30Z")
Thanks for the follow up on this @olgatrykush 😀