How do I calculate 15 working days from 1/1/2006 excluding wkends

's Computer Specifications

's Computer Specifications

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Access question - data claculations" <Access question - data
(E-Mail Removed)> wrote in message
news:7EA6C3DE-BD2D-402B-9FBE-(E-Mail Removed)...
>

's Computer Specifications

If holidays have no part in the calculations. then 15 working days is
ALWAYS equal to 3 weeks or 21 days.

Work it out on your calendar. It works......

Ron

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How To Calculate Due Date And Working Days Excluding Holidays	ladous	Microsoft Access VBA Modules	0	22nd Feb 2006 03:38 AM
formula to calculate # of days between dates, excluding holidays	=?Utf-8?B?YWJzMjI5OQ==?=	Microsoft Excel Misc	8	3rd Mar 2005 02:21 AM
How do I calculate the number of days between two dates, excluding	=?Utf-8?B?Z2lsbHQ5Nw==?=	Microsoft Access	6	11th Jan 2005 07:18 PM
Calculate Days from Dates excluding weekends	Faio	Microsoft Access	1	17th Aug 2004 09:26 AM
Re: how calculate days between two dates excluding weekends and holi.	Myrna Larson	Microsoft Excel Worksheet Functions	0	12th Aug 2004 10:26 PM