Calculate Working days ?

Martin \(Martin Lee\)

Guest

Posts: n/a

24th May 2006

I have two fields: one is begining date, the other is ending date.

I want to make it calculate automatically for the working days between date1
and date2. ( Working days: Monday to Friday, except Saturday and Sunday)

In EXCEL, there is a function called =NETWORKDAYS(date1,date2) which can
calculate the working days. Is there any method in ACCESS?

Thank you.

Martin Lee

« About COMBO BOX 's pull down CLICK list | Sorting by alphabet after new input »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate working days but change working week	SamB	Microsoft Excel Misc	1	1st Sep 2008 09:17 PM
Calculate Working days ?	Martin \(Martin Lee\)	Microsoft Access	14	24th May 2006 03:07 PM
Calculate Working Days Between Two Dates	=?Utf-8?B?R3JlZw==?=	Microsoft Access Form Coding	2	7th Nov 2005 10:51 PM
Calculate Working Days	Kevin C	Microsoft Access Queries	0	23rd Sep 2003 07:47 PM
calculate working days (without holidays)	zarbout	Microsoft Access Forms	3	13th Jul 2003 06:16 PM