WORKDAY for today?

AlFresco

Is there such a thing as a formula for WORKDAY for today?  I.e. modifier is 0 instead of + or -

I'd like a field that can go off another field or (work on itself) that can adjust itself to the closest workday, for example.

=WORKDAY([Due in PROD]1, 0)

Paul Newcome

Try something along the lines of...

 

=WORKDAY(IF(ISDATE([Due in PROD]1), [Due in PROD]1, TODAY()))

 

Basically the IF portion will input whatever date is in the [Due in PROD] column. If there is no date, then it will input TODAY(). It will then run the WORKDAY function based off of that result.