Number of work days between two dates 
Author Message
 Number of work days between two dates

Is there a function/template or does any one have code to calculate the
number of work days (Mon-Fri) between two dates? TIA


Sun, 28 Aug 2005 14:05:11 GMT  
 Number of work days between two dates
Gideon,

     This is nothing fancy, but how bout something like...

WorkDays = 0
Loop DOW = Firstdate to SecondDate
   If DOW%7 = 0 or DOW%7 =6
      Cycle
   Else
      WorkDays +=1
   End
End

   This of course wouldn't take into account holidays, but it would give you
a count of week days.

Marty Honea


Quote:
> Is there a function/template or does any one have code to calculate the
> number of work days (Mon-Fri) between two dates? TIA



Sun, 28 Aug 2005 14:54:04 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Number of working days between dates.

2. Days between two dates

3. HOW 2: Count days between two dates

4. number of days between dates

5. convert a date to a number of days

6. date after adding/subtracting days from date

7. Changing the way numbers work (two proposals)

8. Day of year- the day number

9. Two day job avail

10. Last chance - two days left!

11. Two days left...

12. New price reduction on GREGPlus...Two days left!

 

 
Powered by phpBB® Forum Software