Does anyone know how to calculate the number of months between two dates? Calculating the days is easy per my formula in the image below.
by utilizing the Functions MONTH() and YEAR() you can derive the number of months between 2 date formatted line items with this formula: IF ISBLANK(start date) THEN 0 ELSE IF ISBLANK(end date) THEN YEAR(START()) * 12 + MONTH(START()) - (YEAR(start date) * 12 + MONTH(start date)) ELSE YEAR(end date) * 12 + MONTH(end date) - (YEAR(start date) * 12 + MONTH(start date))
I need to flow data from a model DAT01a in PBF Dev to PBF Consol, we use connectors to do this OUT3A and OUT3B Any instructions or tips on how to build or test the data can be flowed through to PBF Consol?
Hi, My values of monthly commission forecast is not matching the Check your build values. Please help to identify where I am wrong. As I have attached screenshots of the blueprint and module grid view. Thanks, Sre Varshaa S
In our current setup on a Global Engagement, most regions use a Month–Year format (e.g., Jan-26) for the time range in the forecast upload template. However, the US region follows a Year–Month format (e.g., 26-Jan) in their local Excel files. This mismatch creates a challenge: When US users download the template, it is…
