Add Month option in formulas

Feature requests
1

The add days formula function is not useful for this specific use case.

I have a use case in which we create subitems based on a number of payment installments, with separate date columns for reports and payments. These report and payment dates are always on specific days of the month, but the month they happen is dependent on contract start. Using the add days function isn’t helpful since I cannot always get the correct date. Additionally, since not every month is the exact same length, it gets very messy.

Having an add months function would be extremely helpful.

2

Hi @DavidSchenkler,

Try the EDATE function.

FORMAT_DATE(EDATE({Date},6),"YYYY-MM-DD")

should add 6 months to {Date}.

Just run a test and it seems to be adding 6 months minus 1 day, odd. If you get the same result, then:

FORMAT_DATE(ADD_DAYS(EDATE({Date},6),1),"YYYY-MM-DD")

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

1 Like
3

Hi @GCavin ,
Thanks for the idea. I didn’t see it in Monday’s formula knowledge base article; however, it is in one of their examples and it does work.

I’m not getting that it’ll add an extra day though.

Thanks!

1 Like
4

Hi @GCavin ,
I actually just noticed that it does add a day, but ONLY when it comes to February. I’m not seeing it happen with any other month.

Very peculiar.

Still, the goal is to have these formula blocks in order to do something else via a workflow/automation.

For example, I would like these workflows to generate subitems with specific information and dates based on the item’s data. I can’t do that with automations and workflows yet.

There are 3rd party solutions and make options, but I want monday to have this option on its own.

2 Likes
5

Hi! This Monday.com developer has a web page with hidden formulas, maybe it helps?

The monday Hidden Functions – The Monday Man

See ya!

1 Like