Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Business days

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Business days

    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:

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

Latest Posts

Collapse

Topics Statistics Last Post
Started by Geovanny Suaza, 02-11-2026, 06:32 PM
0 responses
558 views
0 likes
Last Post Geovanny Suaza  
Started by Geovanny Suaza, 02-11-2026, 05:51 PM
0 responses
324 views
1 like
Last Post Geovanny Suaza  
Started by Mindset, 02-09-2026, 11:44 AM
0 responses
101 views
0 likes
Last Post Mindset
by Mindset
 
Started by Geovanny Suaza, 02-02-2026, 12:30 PM
0 responses
545 views
1 like
Last Post Geovanny Suaza  
Started by RFrosty, 01-28-2026, 06:49 PM
0 responses
547 views
1 like
Last Post RFrosty
by RFrosty
 
Working...
X