AddDays

  • 16 January 2014
  • 1 reply
  • 1 view

Badge +4

I having a problem with the AddDays inline function, this function doesn't have an option for weekdays only. For example todays is Thrusday, if I used AddDays(Today,2) is going to give Saturday which is fine but I need one that just consider weekdays, business days or even the GMT set up on the workspace.


 


Does anyone have any work around?


1 reply

Badge +13

You need a custom inline or using code, since you also want to skip national holidays right?


If it's always within 7 days you could +2 based if starting date is Friday.    Every extra 5 days you add another 2 day to account for weekend?


http://stackoverflow.com/questions/1044688/add-business-days-and-getbusinessdays

Reply