You need to sign in to do that
Don't have an account?

Formula field showing #Error!
The following formula is shoing an error.
DATE(
YEAR(CurrentEndDate__c + GracePeriod__c ),
(MONTH(CurrentEndDate__c + GracePeriod__c)+1),
(1)
)-1
CurrentEndDate__c = 11/30/2015
GracePeriod__c = 30
Please help!
DATE(
YEAR(CurrentEndDate__c + GracePeriod__c ),
(MONTH(CurrentEndDate__c + GracePeriod__c)+1),
(1)
)-1
CurrentEndDate__c = 11/30/2015
GracePeriod__c = 30
Please help!
I would recommend separating this in three formulas with a nested IF statement
IF ((MONTH(CurrentEndDate__c + GracePeriod__c)+1)<13, {use formula above},IF((MONTH(CurrentEndDate__c + GracePeriod__c)+1)<14,{formula for November},{formula for December},))
All Answers
DATE(
YEAR(CurrentEndDate__c + GracePeriod__c),
MONTH(CurrentEndDate__c + GracePeriod__c) + 1,
1
)- 1
I would recommend separating this in three formulas with a nested IF statement
IF ((MONTH(CurrentEndDate__c + GracePeriod__c)+1)<13, {use formula above},IF((MONTH(CurrentEndDate__c + GracePeriod__c)+1)<14,{formula for November},{formula for December},))