My HR friend Question:
He got the personnel data from Time office in a excel book. The book has number of sheets belongs to various employee attendance, i.e. one sheet for each employee. The data has date and time recorded by the system on use of punch card / Tag.
My Solution:
He can use the 'Networkdays' function to find the missing dates. Please follow the below steps
Step1 : Insert a column next to present dates
Step 2 : Use the function - "=NETWORKDAYS(H5,H6,"Holidayrange")"
Step 3 : Copy and paste the function for all rows
Step 4 : If value is 2 then he is continuously present. If value is more than 2 the he has taken leave in the period.
Note - The function is applicable for five day working only. It will calculate Monday to Friday has working days.
He got the personnel data from Time office in a excel book. The book has number of sheets belongs to various employee attendance, i.e. one sheet for each employee. The data has date and time recorded by the system on use of punch card / Tag.
My Solution:
He can use the 'Networkdays' function to find the missing dates. Please follow the below steps
Step1 : Insert a column next to present dates
Step 2 : Use the function - "=NETWORKDAYS(H5,H6,"Holidayrange")"
Step 3 : Copy and paste the function for all rows
Step 4 : If value is 2 then he is continuously present. If value is more than 2 the he has taken leave in the period.
Note - The function is applicable for five day working only. It will calculate Monday to Friday has working days.
Its a very needful information by Mr. Ss Kumar.This is a very good blog to find all the solutions for your excel queries.
ReplyDeletesap erp 6.0