Discussions

 View Only
  • 1.  Subtract Weekdays from Date to get start date

    Posted 08-04-2017 19:18
    So this is what I have. [Desired In-Market]-ToDays,[Est Days]

    I am wanting to get a start date for a project.
    Team Members can enter the date, pick a schedule and this calculation should spit out when a project should start. The [Est Days] is the number of working days/weekdays that the project should take. Sooooo how do I do this?


  • 2.  RE: Subtract Weekdays from Date to get start date

    Posted 08-08-2017 16:38
    Is this not a thing? Anyone, anyone, Bueller?


  • 3.  RE: Subtract Weekdays from Date to get start date

    Posted 08-08-2017 19:11
    Your field [Desired In-Market] is date/time, your field [Est Days] is numeric, the field [Start Date] is formula - date/time:

    WeekdayAdd (
    ToDate([Desired In-Market]),([Est Days] * -1)
    )