Formula error in WorkdayAdd formula field. HELP!

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a date formula field that I'm trying to get to pull the date from another date field in my table, add 2 days to it, then return the new date, but only if another field - [Number of days] - is greater than 1. So for example, if the [Start date] field contained the date 8/23/2016, and the [Number of days] is 2, I would like it to return the date 8/25/2016. Below is the formula I'm using but I can't figure out what's wrong with it.

If(
[Number of days] > 1, WorkdayAdd([Start date], 3), null
)

Thanks!

Photo of ROBERT

ROBERT

  • 0 Points

Posted 3 years ago

  • 0
  • 1
try this

If(
[Number of days] > 1, WeekDayAdd([Start date], 2))
Photo of ROBERT

ROBERT

  • 0 Points
Thanks for the quick response, but I need to include weekend days in the calculation. I was using the "WorkdayAdd" function because my understanding is that the "WeekdayAdd" function doesn't include weekend days. Am I incorrect?
OK, use this

If([Number of days] > 1, [Start date] + Days(2))
Photo of ROBERT

ROBERT

  • 0 Points
PERFECT! Thanks a million!