How do I calculate the number of days between two dates, excluding

G

Guest

Datediff function e.g.

DateDiff("d",[DateField1],[DateField2])

So if Date1 = 01/11/2005
and Date2 = 01/21/2005
then the datdiff function above would bring back 10.

I think you can replace the "d" with like an "m" to get the number of months
difference. There is probably some good documentation in MSDN as to other
parameters for the intervals for this function. (i.e."d" or "m" etc)
 
G

Guest

Ignore me I must learn to read the question.

Try this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;95977

Whitless said:
Datediff function e.g.

DateDiff("d",[DateField1],[DateField2])

So if Date1 = 01/11/2005
and Date2 = 01/21/2005
then the datdiff function above would bring back 10.

I think you can replace the "d" with like an "m" to get the number of months
difference. There is probably some good documentation in MSDN as to other
parameters for the intervals for this function. (i.e."d" or "m" etc)

gillt97 said:
How do I calculate the number of days between two dates, excluding weekends.
Click to expand...
Click to expand...
 
L

Lynn Trapp

Rick,
While I agree with your attempt to help people to learn how to find the
answers for themselves, quite often people who come to these newsgroups
don't know where to search for the answers. You might want to consider, at
the very least, giving them a suggestion of a possible place to start their
search.
 

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

Number of days between two dates excluding Holidays and weekends. 4
Network days 1
Work Days 5
How do I calculate the number of days excluding holidays and week. 3
Access - Calculate diff between two dates - do not count weekends 2
Count days between two dates excluding weekends 1
Calculate the number of days in work week from start date to end d 3
Calculate elapsed time excluding time for breaks, lunch, etc 2

Top