Incrementing a date by 2 business days?

Question

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
------------------------------

markshnier__you · Answer

npWeekDayAdd([Input Date Date],2)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

mrunalikadam · Answer

Great! thank you Mark!However, Field type of Input Date field is date/time. Could you please help with it?&nbsp;------------------------------Mrunali Kadam------------------------------

markshnier__you · Answer

OK, a bit more complicated ....var date NewDate = WeekdayAdd(ToDate([date &amp; time field]),2);var timeofday TOD = ToTimeOfDay([date &amp; time field]);ToTimestamp($NewDate, $TOD)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

mrunalikadam · Answer

Perfect. It worked!As always thank you very much for the quick turnaround :)------------------------------Mrunali Kadam------------------------------

Forum Discussion

Incrementing a date by 2 business days?