|
midrange.com
this doesn't always work.
from today 8/23 (julian 236)
for 10 days: (10/5)*7= 2*7=14 thus julian 250 (correct)
for 11 days: (11/5)*7= 2.2 *7= 15.4 julian 251 (correct)
for 23 days: (23/5)*7= 4.6 *7=32.2 julian 268 (wrong - and its a
sunday. 23 work days out from today, assuming no holidays, is jul 269)
if you always round up, making the 23 days example correct, then the
11 day example is now wrong. if you round after the first
calculation, then you're really off. of course, this is a leap year.
jw
______________________________ Reply Separator _________________________________
Subject: Re: Calculating Working(business) days
Author: Alan Addison <ahaddison@home.com> at Internet
Date: 08/23/2000 7:00 PM
Take the duration, divide it by five and multiply it by seven, then add
that number of days to the starting date.
oludare wrote:
> Hi guys,
>
> Is there a tool or utility that can be use to calculate a date from a
> given
> date with a duration of 'n' business days (Mon-Fri).
> (assume no holidays)
>
> Dare
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <body bgcolor="#FFFFFF"> Take the duration, divide it by five and multiply it by seven, then add that number of days to the starting date. <br> <br> <p>oludare wrote: <blockquote TYPE=CITE><style></style> Hi guys, <p>Is there a tool or utility that can be use to calculate a date from a given <br>date with a duration of 'n' business days (Mon-Fri). <br>(assume no holidays) <p>Dare</blockquote> </body> </html>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
