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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating business days

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Hello,

Is there a way to compare two dates and calculate the number of buisness days (M-F) between them. For instance 2/2/01 -2/8/01 would be 4 days.

Thank you for any suggestions you can give.
 
Sort by date Sort by votes
Read MichaelRed's FAQ in this forum faq181-261 .

Or, click the FAQ tab at the top of this Access forum and look for his handle.

Mike Rohde
rohdem@marshallengines.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tav1035
  • Locked
  • Question
access formula approach (RD workorders within 15 days of the closing of the last PM workorder)
Replies
1
Views
150
lameid
lameid
EricFrost
  • Locked
  • Helpful tip
Geocoding and Calculating Driving Distances with Access VBA and MapPoint
Replies
0
Views
221
EricFrost
EricFrost
bri00032
  • Locked
  • Question
Calculating date with and without weekends. 1
Replies
5
Views
195
MichaelRed
MichaelRed
HacH
  • Locked
  • Question
Calculating working days (NetWorkdays) not working in Access 2
Replies
4
Views
146
HacH
HacH
jcfraun
  • Locked
  • Question
Calculating trends in data/Notification of data changes
Replies
7
Views
214
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top