Need Help Empolyee Attendance tracker

[sanjeevi888]

Dear Experts,

Please Find the attachment.
and please give solution for monthly employee attendance current day present, training & invoice auto updating...
waiting for replay... Thanks :)

Regards,

Sanjeevi

[Excel Fox]

Used two named ranges

rngSL=Sheet1!$A$7:INDEX(Sheet1!$A$7:$A$100,MATCH(9 999,Sheet1!$A$7:$A$100))
rngDay=OFFSET(rngSl,0,1+MATCH(Sheet1!$AK$2,Sheet1! $C$4:$AF$4,0),,1)

And a few COUNTIFs

[sanjeevi888]

Thank U very much for yours quick response.

Thank u. Thank u.. Thank u...