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.
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)