• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula for Aging using only business days

C

Cathy Wilkerson

New Member
Hello. I need help in determining how to tell Excel to calculate aging based on business days only. For example, my company provides services on M-F only. Therefore, when aging open cases I need to exclude Sat and Sun. Originally I was subtracting the open date from the current date and using a nested if statement to return 1 Day, 2 Days, etc - however did not take Sat and Sun into account. Can anyone guide me? (Nested if statements are about as complicated as I have the capability of doing...)
Thanks
 
The WORKDAY function is going to be your friend. Syntax is:
=WORKDAY(StartDate,EndDate,[holidays])

The 3rd argument is option, in which you can give a range of cells that contain company holidays. The WORKDAY function will return the number of weekdays between start/end, and is an inclusive count. E.g., if StartDate is today (Monday) and endDate is tomorrow, function will return 2.
 
You must log in or register to reply here.
Back
Top