PDA

View Full Version : Business days


MrBaffalo
03-05-2007, 01:01 AM
Hi All!

How can I get the number of business days from a date to another? I'm looking to convert a ts function called "BUSINESSDAYS" which returns:

BusinessDays considers a business day to be Monday through Friday only. The Function DateToJulian may be used to convert a standard date to Julian for the REFDATE Input.

Example

Assigns to Value1 the number of 20 business days forward from the Julian date 35,000 (10/28/95), which is Julian date 35,027 (11/24/95):

Value1 = BusinessDays(35000, 20, 1);

Assigns to Value2 the number of 30 business days back from Julian date 35,880 (3/26/98), which is Julian date 35,853 (2/27/98):

Value2 = BusinessDays(35880,30,False);



Thanks in advance for help,

regards

Marce