Skip to main content Stream TDX Bengaluru on Salesforce+. Start learning the critical skills you need to build and deploy trusted autonomous agents with Agentforce. Register for free.
GruppenAdmin TrailblazersFrage von Tania García Montoya
Tania García Montoya (MIT) fragte in Admin Trailblazers
14. Sept. 2022, 21:27

Formula to get the second business day of each month

Hi all

I hope you can help me, I am making a formula type field that is date, in the formula I want it to calculate the second business day of each month, since I am going to use that field to trigger emails to customers, but no I find a way to calculate the second business day of each month

 

Thanks and Regards

Tania García

6 Antworten
  1. Keiji Otsubo (Fukada Electric Co.,Ltd.)
    14. Sept. 2022, 23:29

    Next month :

     

    IF ( MONTH(TODAY()) != 12,
    CASE(WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,2)),
    1,DATE(YEAR(TODAY()),MONTH(TODAY())+1,3),
    7,DATE(YEAR(TODAY()),MONTH(TODAY())+1,4),
    DATE(YEAR(TODAY()),MONTH(TODAY())+1,2)) ),
    CASE(WEEKDAY(DATE(YEAR(TODAY())+1,1,2)),
    1,DATE(YEAR(TODAY())+1,1,3),
    7,DATE(YEAR(TODAY())+1,1,4),
    DATE(YEAR(TODAY())+1,1,2)) )
    )
Ladevorgang läuft
Antwort schreiben...
0/9000