Weekday only in Datediff function ?


K

Ken

I'm trying to calculate the number of weekdays (Monday to Friday)
between two dates, I can use the Datediff function to get all days
between the start and end dates but can't figure out how to get the
number of weekdays only in the result, is this possible with functions
or does it require vba.
Thanks in advance for any help given.
 
Ad

Advertisements

R

RuralGuy

I'm trying to calculate the number of weekdays (Monday to Friday)
between two dates, I can use the Datediff function to get all days
between the start and end dates but can't figure out how to get the
number of weekdays only in the result, is this possible with functions
or does it require vba.
Thanks in advance for any help given.
I'll bet something on this link will help.
http://www.pacificdb.com.au/MVP/Code/Dates.htm
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
D

Douglas J. Steele

The DateDiff function, by itself, can't do it, but there are tricks you can
use if you're trying to avoid writing your own function.

Take a look at my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/djsteele/SmartAccess.html
 
Ad

Advertisements

K

Ken

Thank you all for the help and links given it's appreciated, I'll
check these out.

Thanks again
Regards Ken.
 

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

Datediff Function 1
Datediff function and date format 1
DateDiff 5
datediff 5
DATEDIFF - THE TRUTH 1
HOW USE FUNCTION WEEKDAYNAME OR WEEKDAY IN ACCES 1
DateDiff on Several days 2
Calculating Working Weekdays 2

Top