I have a date field and its a fromula field i need a formula to add 11months to one of the other date fields. formula has to be like it has to add 11months and need to display lastday of the month in my formula tried all the cases DATE((YEAR(MyCustome_Field__c)+FLOOR(((MONTH(MyCustome_Field__c)+ 11)-1)/12)),MOD((MONTH(MyCustome_Field__c)+ 11)-1,12)+1,DAY( (DATE(YEAR(MyCustome_Field__c),MONTH(MyCustome_Field__c),1)-1)))I have written this formula but it is not working fine for march i dont know why it is acting weird if i give any date except date in march it is working fine but if i give date in march saylike 12-03-16 it has to show 28-02-17 but it is showing ⌗Error for other months it is working fine help me with this.
