example: date1 is 11/19/09 , what date is 3 businessdays from that?The answer is 11/24/09 ( not including the 11/19/09 date ).
I would like an idea of how to start ( with or without taking into consideration holidays )
Thanks…
Subject: @businessdays
This returns the number of days between two dates - so start at three days ahead, check the no. of days, if not 3 then add 1 (or 2 or 3)
This won’t take holidays into account of course, to do this would get more complicated as you’d need some way of looking them up - a dblookup to check the dates from a view and add extra days if a holiday doc is found should work though, can do this is a loop in formula
Subject: This article shows how to calculate a date X business days from now
http://www-10.lotus.com/ldd/ddwiki.nsf/dx/05022009100728PMAGU5MB.htm