I'm trying to create a Date Formula field that will check and see if the Date Value that will be placed into that field is still within the same month as another field and then if it is populate the field. If not then leave it blank.
Also, the Month_Copy__c field below is a text field that will display the month like August.
IF( TEXT(MONTH(End_Date_W4__c + 3)) = Month_Copy__c, End_Date_W4__c + 3, null)
So, If End Date + 3 days is still in the month August then go ahead and populate this field with End Date + 3 Days, if not then null. I just tested this and the field is returning null when it should be populated. Thanks