Hi Team, I need your help for calculating Last Working Date from attached format.
As per policy below mention attendance legends count as a working day P Present HD Half Day COD Comp Off Due PL Privilege Leave CL Casual Leave SL Sick Leave LP Loss Of Pay ML Maternity Leave O Weekly Off CO Comp Off UL Unplanned Leave H Fixed Holiday FH Floating Holiday and A Abconding RD Ramp Down R Desired Exit UR Undesired Exit Above legends mark for inactive cases. **I Send you a file with example please help me for this. Trust me you are doing great JOB !!!! Regards, Surendra Regards, Surendra Singh 9301334795 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Last_Working_Date.xls
Description: Binary data
