How to get a date formula to skip a holiday date?

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

I've got a formula to add expected delivery date, WeekdayAdd([Date Requested],2). This works perfectly. However, I need to filter out for if July 4, 2016 it adds an extra day for delivery date. I tried this, but it's not changing the expected deliver date to July 5 rather than July 4. Any ideas?

If([Date Requested]=ToDate("07-04-2016"),WeekdayAdd([Date Requested],3),

WeekdayAdd([Date Requested],2))

Photo of Dawn

Dawn

  • 40 Points

Posted 3 years ago

  • 0
  • 1
Your formula is correct.  Have you tested it on a record where the [Date Requested] is July 4th 2016?  What is the name of this formula field and what is the result in this formula field?
Photo of Dawn

Dawn

  • 40 Points
Duh, the date requested should actually be 6-30-16 to get the delivery date to be July 5 rather than July 4! Worked like a charm! :) Thanks for helping me solve my own dilemma!
:)