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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Working Days

Status
Not open for further replies.
gGoodson

gGoodson

Programmer
Jul 11, 2001
5
0
0
GB
Can anybody help with calculating the number of working days (e.g. Mon-Fri) between two dates.
 
Sort by date Sort by votes
Short way. (without taking into account of holidays)

Calculate the days difference.
Diff = ToDate - FromDate
Remainder = Diff mod 7
If Remainder = 6 then
Remainder = 5
End If
Working Days = Int(Diff / 7) * 5 + Remainder

 
Upvote 0 Downvote
The best way is to create a Time Dimension. Check Ralph Kimbell's book on Data Warehousing. Gives a good generic time dimension.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
72
tushargaurav
tushargaurav
oldCognosUser
  • Locked
  • Question
counting business days without Sa/Su
Replies
0
Views
33
oldCognosUser
oldCognosUser
scabral1979
  • Locked
  • Question
Radio Button onchange javascript not working
Replies
0
Views
31
scabral1979
scabral1979
mdcson
  • Locked
  • Question
AR Days by Month Calculation
Replies
0
Views
37
mdcson
mdcson
nolanma
  • Locked
  • Question
Count Consecutive Days
Replies
2
Views
52
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top