You can take idea from what I have done in the attached file.
On Tue, Nov 16, 2010 at 3:38 PM, Surendra <shindaro...@rediffmail.com>wrote: > Good After Noon Team, > > Still, Waiting for your response. > > > Regards, > Surnedra > > > On Mon, 15 Nov 2010 15:28:43 +0530 wrote > > >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 > > > > Regards, > > Surendra Singh > 9301334795 > > <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline....@middle?> > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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(1).xls
Description: MS-Excel spreadsheet
