ActPresentation.com HOME FAQ FORUM info@ActPresentation.com
Phorum: speed & power.

ActPresentation.com


Add-ons for Sage ACT! CRM

ACT! addons by ActPresentation.com : Abacus Calculated Fields, PicturePlus, Quick Navigation List, Employment History, Quick Search, Presentation for ACT!

DATE "Workday" calculations

Posted by: Scott H.

Date: December 12, 2008 02:31PM

I would like to use Abacus to calculate a timeline based on certain dates, and business days. For example:
"product arrival date" field is Monday "12/1/08", Set up time is 6 WEEK DAYS so "set up time" field is set to 6. I need the end result to be Monday "12/8/08". Not Sunday "12/7/08".
This is done in Excel by using the "WORKDAY" function. I can Almost get it to work in Abacus by using the "DATEADD" function, but it adds straight days only, so my results may be on a weekend, when nobody is working.

Any help on this would be greatly appreciated!


Thanks.

-Scott

ACT! software CRM addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.