+4I'm using a simple formula to calculate the due date difference between today and the project due date:
WORKDAY_DIFF(TODAY(), {Due Date})-1
Best answer by TheTimeSavingCo
WORKDAY_DIFF outputs "1" for the difference between the same day, so one day ago outputs "-2", your formula then does a "-1", so it's doing "-2-1", resulting in "-3"
Try using an IF to handle it, and here's an example where "TODAY()" is harcoded as a field:
IF(
WORKDAY_DIFF(
Date,
{TODAY()}
)>0,
WORKDAY_DIFF(
Date,
{TODAY()}
) - 1,
WORKDAY_DIFF(
Date,
{TODAY()}
) + 1
)
+31WORKDAY_DIFF outputs "1" for the difference between the same day, so one day ago outputs "-2", your formula then does a "-1", so it's doing "-2-1", resulting in "-3"
Try using an IF to handle it, and here's an example where "TODAY()" is harcoded as a field:
IF(
WORKDAY_DIFF(
Date,
{TODAY()}
)>0,
WORKDAY_DIFF(
Date,
{TODAY()}
) - 1,
WORKDAY_DIFF(
Date,
{TODAY()}
) + 1
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.