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")
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
Post a Comment