Skip to main content
Question

Subtract Weekdays from Date to get start date

  • August 4, 2017
  • 0 replies
  • 53 views
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?
    This topic has been closed for replies.

    Is this not a thing? Anyone, anyone, Bueller?
    • LisaSell1
    • Registered
    • August 8, 2017
    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)
    )
    Terms & ConditionsAccessibility statement