PC Review


Reply
Thread Tools Rate Thread

how to calculate 15 working days of a certaing record

 
 
=?Utf-8?B?cG5leHM=?=
Guest
Posts: n/a
 
      6th Nov 2007
VBA Master,
i just want to ask on how to calculate only the 15 working days of a
certaing record (dont mind the holidays only the saturdars and sundays will
be disregard on count).

hope you can help me. many thanks.

pnexs ignus


--
just need help
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      6th Nov 2007
One approach is outlined in http://www.mvps.org/access/datetime/date0012.htm
at "The Access Web".

I showed another way in 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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"pnexs" <(E-Mail Removed)> wrote in message
newsD10AABB-BCC6-4C9E-A0F5-(E-Mail Removed)...
> VBA Master,
> i just want to ask on how to calculate only the 15 working days of a
> certaing record (dont mind the holidays only the saturdars and sundays
> will
> be disregard on count).
>
> hope you can help me. many thanks.
>
> pnexs ignus
>
>
> --
> just need help



 
Reply With Quote
Reply

Thread Tools
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


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 0 24th May 2006 08:16 AM
Calculate the number days from previous record =?Utf-8?B?RG91Z2xhcyBNZXJyaWxs?= Microsoft Access 7 27th Jun 2005 01:18 PM
Calculate the working days between 2 dates in the same record dano0097 Microsoft Access Queries 1 6th Jan 2004 11:05 PM
Calculate Working Days Kevin C Microsoft Access Queries 0 23rd Sep 2003 07:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:05 PM.