Determining Number of Working Days
Q. I need to be able to calculate the number of working days between two dates. I know I can convert both dates to Julian dates and then subtract, but this number includes weekends. Is there a quick, cheap formula out there to do this?
A. The correct way to calculate the number of workdays would be to determine the day of the week for both dates so you know how many weekends to subtract. This, of course, doesn't account for holidays. If you're looking for a quick, cheap formula, how about this:
Calculate the number of days between the two dates as you suggested. Then multiply by 5 and divide by 7. This gives you an approximated result. The result is exact only when both dates fall on the same day of the week.
LATEST COMMENTS
MC Press Online