Forum Discussion

MeredithMoore1's avatar
MeredithMoore1
Qrew Cadet
8 years ago

Subtract Weekdays from Date to get start date

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?
Formulas and functions
  • LisaSell1's avatar
    LisaSell1
    Qrew Trainee
    8 years ago
    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)
    )