Date difference in month

Julien_Gattoni · April 10, 2024, 1:15pm

Hi everyone,
I’m new to causal and building a GP P&L model for a PE firm (incl. management fee calculation).
How do I calculate the difference between two date expressed in month?
Thanks for your help
Best
Julien

lorenz_causal · April 16, 2024, 8:09pm

Hey Julien, if you have a monthly model you just have to subtract the two dates:

You can find more information about how dates work in Causal here: Working with time - Causal University

Julien_Gattoni · April 16, 2024, 8:13pm

Thanks Lorenz! Much appreciated

Topic		Replies	Views
dayOfMonth also in monthly models (to extrapolate a "month-to-date" value to the full month) Feature requests	2	383	February 21, 2022
Comparing same months of different years Feature requests	3	480	November 2, 2021
Link live Google Sheets to Causal and input set dates into the correct monthly column How do I?	5	412	March 29, 2022
How do I build a revenue recognition model for annual contracts in Causal? How do I?	4	421	December 14, 2022
How do you change the date range from a cloned template without upsetting the variables? How do I?	1	391	March 8, 2022

Date difference in month

Related topics