Guidelines to calculate of Man days and Absenteeism?

Please Give me anyone to guidelines to calculate of Man days and Absenteeism.

Hi,,
To calculate mandays,
1.No. of days work in the month Except Weekly off and Paid Holday( declared by company)
2.No. of working days for the month
2.

Dear seniors
I will give one example. Please calculate manpower utilisation in %
Category I work Mandays in month for 31 days 286 mandays
Category II work Mandays in month for 27 (without sundays) 486 mandays
In category I, per day 10 manpower are supposed to deploy for 31 full days
In category II, per day 20 manpower are supploed to deploy for 27 days (sundays not working)
I request to calculate manpower utilisation in %.
The result may in excel sheets.
M Srinivas
[Login to view]

1 No Of Empolyee Empolyee work Day Mandays Manger/ Supervisor Other Empolyee Regular worker M/F
Apr-13 33 25 7 14 12
May-13 31 27 7 11 13
Jun-13 31 26 7 12 12
Jul-13 33 26 7 13 13
Aug-13 29 26 6 11 12
Sep-13 29 25 6 10 13
Oct-13 28 25 6 11 11
Nov-13 29 24 6 11 12
Dec-13 29 26 6 11 12
Jan-14 25 25 6 10 9
Feb-14 23 24 4 10 9
Mar-14 24 25 4 9 11

Hpw to calculate 1 employee Manday in month

How to calculate 1 Employee Mandays in a Month

For calculating total man days of the month of any of the employee/worker is to be considered as total present of the month.
R N KHOLA

how to calculate absenteeism mandays in month