'Quarterly' is every three months
'Semi-Annual' is every six months
And 'Annual' is every 12 months.
Any idea of the formular required on this based on the below?
답변 3개
Hi Brooke, This is similar to the other question you posted. Please try this:
ADDMONTHS(Start_Date__c,
(CEILING((12*(YEAR(TODAY())-YEAR(Start_Date__c)) + (MONTH(TODAY()) - MONTH(Start_Date__c))) / CASE(Payment_Frequency__c,
"Monthly", 1,
"Quarterly", 3,
"Semi-Annual", 6,
"Annual", 12,
null)) + IF(AND(MOD(MONTH(TODAY()) - MONTH(Start_Date__c), CASE(Payment_Frequency__c,
"Monthly", 1,
"Quarterly", 3,
"Semi-Annual", 6,
"Annual", 12,
null)) = 0, DAY(TODAY()) >= DAY(Start_Date__c)), 1, 0))
*
CASE(Payment_Frequency__c,
"Monthly", 1,
"Quarterly", 3,
"Semi-Annual", 6,
"Annual", 12,
null)
)
