Having a start date and a monthly subscription price, I would like to calculate the Lifetimevalue of a client. Therefor I need to know how many months the client has been active. I couldn’t find a way to calculate that with the formulas. I tried different possibilities using the formulas DATE, DATEVALUE, MINUS, MULTIPLY, TIME, TIMEVALUE and more.
Has anyone an idea how to do it?