>>Hello everyone,
>>
>>How would one go about calculating work days?
>>
>>Appreciate any suggestions/help,
>>
>>Jamuna
>
>Here's my idea:
>
>days = (date2-date1)
>workdays = days * 5/7
>
>If the first and last DOW() are different adjust days to be a multiple of 7 before hand and make the revrse adjustment to workdays afterthe calculation.
>
>lastly, you'll need an array or table, or just a text list of dates that are holidays. Subtract one for each that is in the range.
>
>HTH
you only work 5 days a week?