Formula Help - Calculate days between timeline column when spanning two calendar years

Platform discussions
, , ,
1

I’m trying to create a formula that calculates the number of days between a timeline column including the start and end date. I modified a sample formula I found in the Monday.com help center and it works except for one scenario.

Here’s the formula I’m using:
DAYS({dates#End},{dates#Start})-(2*(WEEKNUM({dates#End})-WEEKNUM({dates#Start})))+1

The problem only occurs when the start and end dates span two different years. 12/26/24-12/31/24 returns 4 days as it should, but 12/24/24-1/3/25 returns 113 days when it should be returning 9 days. Can anyone help me troubleshoot this?

2

Hi @lakerfaninflorida,

Why don’t you simply use?

DAYS({dates#End},{dates#Start})-1

 

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.