Get Week of Month in a Salesforce Formula Field
…of the date we want to get the week of the month of. Once we have the difference in days we can take that value divided by 7 less the remainder to get the day of the week index. Completed Formula CEILING( ( DAY( Date__c ) + MOD( DATE( YEAR( Date__c ), MONTH( Date__c ), 1 ) – DATE( 1900, 4, 1 ), 7 ) ) / 7 )…