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