Get Date for the First Weekday of the Month #inSalesforce

Get Date for the First Weekday of the Month #inSalesforce


IF(
 OR(
   AND(
      Day(Date__c)=1, 
      MOD(DATE(YEAR(Date__c),MONTH(Date__c),Day(Date__c)) - DATE(1900, 1, 7),7) <> 0,
      MOD(DATE(YEAR(Date__c),MONTH(Date__c),Day(Date__c)) - DATE(1900, 1, 7),7) <> 6
      ),
   AND(
      Day(Date__c)=2, 
      MOD(DATE(YEAR(Date__c),MONTH(Date__c),Day(Date__c) ) - DATE(1900, 1, 7),7) = 1
      ),
   AND(
      Day(Date__c)=3, 
      MOD(DATE(YEAR(Date__c),MONTH(Date__c),Day(Date__c) ) - DATE(1900, 1, 7),7) = 1
      )
  ),
"YES" 
,"NO")

Comments