count of days from 2 date columns EXCLUDING SATURDAY AND SUN

[system]

This post may also help

120×120 10.4 KB

How do I calculate number of working days in a month? If an employee works for 5 days in a week, how many days he will be working in a month? Similarly, if he works for 6 days in a week, how many days he will be working in a month? Similarly, if he works for 7 days in a week, how many days he will be working in a month? So far I am able to calculate 7 working days <7 Working Days> =DaysBetween(<Month> ,<Last Day of month>)+1 kool (BOB member since 2005-04-15)

---

MBTDC (BOB member since 2007-12-28)