Subtract Weekdays from Date to get start date

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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?
Photo of Meredith Moore

Meredith Moore

  • 556 Points 500 badge 2x thumb
  • kerfuffled

Posted 1 year ago

  • 0
  • 1
Photo of Meredith Moore

Meredith Moore

  • 556 Points 500 badge 2x thumb
Is this not a thing? Anyone, anyone, Bueller?
Photo of Lisa

Lisa

  • 210 Points 100 badge 2x thumb
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)
)