Monthly Countdown

Platform discussions Special workflows & use cases
1

Hey,

Is there a way to let me know how many full months are left from today to an end date of a timeline, and display this numerically.

I want to be able to forecast future monthly revenue based on multiplying remaining months against a monthly fee column and I’m struggling to get a column to display remaining months.

2

Hi @Matt_Frost,

This formula will give you the number of days:

DATEVALUE({Timeline#End})-DATEVALUE(FORMAT_DATE(NOW(),"yyyy-MM-DD"))

You can divide it by 30 and round it down (not sure what your definition of full months is):

ROUNDDOWN(DIVIDE(DATEVALUE({Timeline#End})-DATEVALUE(FORMAT_DATE(NOW(),"yyyy-MM-DD")),30),0)