Re: Calculating # of working days in a period.
Date: 1 Nov 1994 17:06:04 GMT
Message-ID: <395shs$daf_at_fred.uswnvg.com>
ispa (ispa_at_beagle.ispa.fsu.edu) wrote:
: I want to calculate the number of working days in a
: period, assuming a work of week of 5 days. It should
: be simple enough, count the number days in the period
: minus the weekends. But, I also want to eliminate
: holidays. Is there a simple solution to this?
There is a formula to do this. I had done it twice but it was so long ago that I forgot how. It has something to do with converting it to Julian date and checking the beginning and/or end day. The holidays, however, will have to be stored in a table since they are not the same every year. Then, you just need to count how many holidays are between the dates you are interested in and subtract that from whatever result you get from the formula.
Hope that help.
Kim Ng
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!) Received on Tue Nov 01 1994 - 18:06:04 CET