we can calculate the number of absents of an employee in a current month excluding weekend days by using following SQL query in MySql.
SELECT COUNT(*) AS total FROM attendence WHERE absent='true' AND emp_id='3052' AND DATE_FORMAT(DATE,'%Y-%m')='2011-07' AND DAYOFWEEK(DATE) NOT IN (1,7)
