Discussions

Expand all | Collapse all

Calculating a date based on business days?

  • 1.  Calculating a date based on business days?

    Posted 06-23-2017 19:10
    This one may be an easy one for you guys, but I'm blanking out. 

    I have a field called [Date Agency Contacted]. 

    I need to calculate a follow up date based on a multiple choice field called [Follow Up Days]
    and have that populate into the date - formula field [Follow up Date]

    The catch is that I need it to only count business days

    I have this for now ;

    ToWeekdayN([Date Agency Contacted] + Days(ToNumber(Left([Follow Up Days], " "))))


    Only issue is that it's not skipping weekends in the count; just making sure the last day lands on a weekday.

    Any help?


  • 2.  RE: Calculating a date based on business days?

    Posted 06-23-2017 19:30
    Try this


    var number DaysToFollowUp = ToNumber(Left([Follow Up Days], " "));

    WeekdayAdd([Date Agency Contacted], $DaysToFollowUp)


  • 3.  RE: Calculating a date based on business days?

    Posted 06-23-2017 19:39
    You never disappoint, works perfectly.