I was wondering if there is anyway to calculate the number of working days between two dates without using a macro or VB script (we are not allowed to do so)? Not sure if anyone has done this or if anyone has any suggestions. I am not concerned about the Holiday issue. Any and all suggestions welcome. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Working days between date w/o vb
- Thread starter kevinko
- Start date
Our service department had the same requirement to calculate the number of working days it takes them to handle repair-returns. I created a special calenderfile (for the next 10 years) that omits the weekends and all established cristian holidays. The file has a running counter incrementing with 1 for each entry in the file. Establishing the datedifference is then a question of subtracting the respective counters............... T. Blom
Information analyst
tbl@shimano-eu.com
Information analyst
tbl@shimano-eu.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question