Formula count between months

Platform discussions
, ,
1

Hi,
What formula can I use to calculate the number of months between two columns?

So in the below example, I want the formula to pull back the result 5.

image

2

Hi Hayley,

To get the date of January 1, 2024

DATEVALUE(CONCATENATE({Starting Month}," 1, ",{Year}))

To count the number of days between the 2 dates:

DAYS({Date},DATEVALUE(CONCATENATE({Starting Month}," 1, ",{Year})))

Then you could divide by 30 and round up or down depending on how you want to count it.

ROUNDUP(DIVIDE(DAYS({Date},DATEVALUE(CONCATENATE({Starting Month}," 1, ",{Year}))),30),0)

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

:heart_eyes: Thank you so much!