I'm looking for a formula that returns a date in the future given a start date (manually to enter) plus a certain duration (in months). So e.g. the start date is today and in the term field I have 50months ->it should return me the exact date in the future (today + 50 months). As of now I only have a formula that gives me a rough estimate but is not considering the different leap years and is also not considering that month have differen amount of days. Is there a formula that properly caluclates that?
Many thanks for your help,
Philipp
38 个回答
So you basically want this? (ADDMONTHS(Subscription_Start_Date__c, FLOOR( Subscription_Term__c))
+
FLOOR(
(Subscription_Term__c - FLOOR( Subscription_Term__c )) *
DAY(ADDMONTHS(DATE(YEAR(Subscription_Start_Date__c),MONTH(Subscription_Start_Date__c), 01), Subscription_Term__c) - 1)
)) - 1
