Skip to main content
Question

Incrementing a date by 2 business days?

  • June 1, 2022
  • 0 replies
  • 85 views

I've a field called output date which needs to be incremented by 2 business days per  input date
e.g. Input date + 2 business days =Output date

Can you please help with the formula that can do this calculation?

My current formula for the output date field (([Input Date Date]+Days(2))) doesn't understand business days logic and directly increments by 2 days.

------------------------------
Mrunali Kadam
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np
WeekDayAdd([Input Date Date],2)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------