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