Attendance tracking

[yogananda.muthaiah]

Dear Experts,

I would require all your help in getting this requirement complete


List of Requirement

1 ) Need to alter the formula for Range from 1st to 30th April 2012 where ever Saturday and Sunday as "WO" in Brown highlighted column - Refer Tracker Sheet
2) Employee No : 42244 as taken LOP leave then it should update total no of days as LOP leave taken (including saturday and sunday ) and
in Total Leave summary should reflect as 6 days instead of 4 days - Refer Upload Sheet
3) In Resigned sheet - Once Employee code no inputs in "A" Column the Flash or Blinking warning should come ( Already VB code is done only alternation needs to be done)
4) If any Employee takes AL in continous 5days in date range then should highlight as BL in total leave summary column
5 ) In Holiday List Sheet - Once the Holiday date is entered , then H should reflect in Tracker sheet as per the Date (Example is in Holiday list sheet)