Days passed minus weekends

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have 2 date columns and I want to calculate the number of BUSINESS days
that has passed between them, how can I do that?
 
I'm new to access, can I just put the function directly in design view or
does this require me using VBA code...

Pls advise.
 
The functions are VBA code, but they are already written for you. All you
have to do is paste the functions you want to use into a new Module, then use
them wherever you want to calculate workdays, whether that's a field in a
Query, or a control on a Form or Report. You can also use them in any other
VBA code you may write yourself.

-Michael
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access - Calculate diff between two dates - do not count weekends 2
Work Days 5
Date Calculation for Report 20
Date Diff 6
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Business Days Between Two Dates? 4
Subtract WorkDays 4
Steele's Diff2Dates Function without Holidays & Weekends 4

Back
Top