Dear Sir, Problem partially solved. Result Cell should be blank if an employee is already joined and now working.I have to find out continuous leave of an employee from a particular date till today.Also highlight with colour thro. conditional formating. Enclosed file ...
Regards. On 9/14/10, ashish koul <koul.ash...@gmail.com> wrote: > > hi check it see if it helps you also please post the question on group as > well because may be someone will give you better solution than mine.... > > > On Tue, Sep 14, 2010 at 3:58 PM, Nalini P <nalini.pradha...@gmail.com>wrote: > >> >> Dear Sir, >> >> Please find the attached File. >> >> Regards. >> >> On 9/13/10, ashish koul <koul.ash...@gmail.com> wrote: >>> >>> can you please attach excel file >>> >>> On Mon, Sep 13, 2010 at 11:57 AM, Nalini <nalini.pradha...@gmail.com>wrote: >>> >>>> Dear Sirs, >>>> >>>> I want to capture data which employees are on leave as on date and >>>> since when ? >>>> Formula please….. >>>> >>>> (Format enclosed) >>>> >>>> NAME 01-Sep 02-Sep 03-Sep 04-Sep 05-Sep 06-Sep 07-Sep Leave >>>> Since >>>> A AB AB AB AB AB AB AB 01-Sep >>>> B pr pr pr pr pr pr pr >>>> C pr pr pr AB AB AB AB 04-Sep >>>> D pr pr pr pr pr pr AB 07-Sep >>>> E ab AB AB pr AB AB pr >>>> >>>> Thanks & Regards. >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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 >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 7000 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> >>> >> > > -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Copy of leave formula.xls
Description: MS-Excel spreadsheet
