+ Reply to Thread
Results 1 to 9 of 9

Attendance to identify the absent date

  1. #1
    Registered User
    Join Date
    09-20-2014
    Location
    riyadh
    MS-Off Ver
    2013
    Posts
    9

    Attendance to identify the absent date

    Good day guys, I need your help in my attendance log to scan all start date and end date and result the absent date
    example

    Name--------------Start date-----------------End date

    John---------------june 1 2014---------------june 15 2014
    John---------------june 17 2014--------------june 30 2014
    edward------------june 1 2014--------------june 7 2014
    edward------------june 10 2014-------------june 30 2014





    Result

    John absent - ----June 16 2014
    edward absent - ---- June 8 2014 and june 9 2014


    I have a thousand data and its hard to do it manually. I attach the sample - hope someone can help me

    Thanks for your help..
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: Attendance to identify the absent date

    Hi junbone,
    Welcome to the Forum.

    If you are open to a VBA solution to achieve this, try this.....
    Please Login or Register  to view this content.
    You can change the range reference codes in red as per your actual workbook.

    To apply this code to workbook follow these steps.
    1. Open your workbook
    2. Press Alt+F11 to open VBA Editor
    3. Click on Insert --> Module
    4. Paste the above code in opened code window.
    5. Close VBA Editor
    6. Save your workbook as Excel Macro-Enabled Workbook
    7. To Run the code, Press Alt+F8 to open Macro Window.
    8. Select Attendance macro from the macro list
    9. Run
    Please find the attached sheet and click on the Green Button to get the desired output.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    09-20-2014
    Location
    riyadh
    MS-Off Ver
    2013
    Posts
    9

    Re: Attendance to identify the absent date

    WOW, I was amazed by your expertise in VBA, I really this is what i need. unfortunately i am not expert and I dont know how to apply it in my real file , can you put explanation in the code?

    Thanks a lot Mr. Sktneer

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Attendance to identify the absent date

    Hi Junbone..
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag down and horizontally...
    Check the attached file...
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: Attendance to identify the absent date

    If you are not familiar with VBA, in that case you should go with the formula suggested by Vikas. Because to change the code as per your requirement requires some basic understanding of VBA.

  6. #6
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Attendance to identify the absent date

    Thanks Sktneer for reputation point..
    This really means a lot..


    Regards,

  7. #7
    Registered User
    Join Date
    09-20-2014
    Location
    riyadh
    MS-Off Ver
    2013
    Posts
    9

    Re: Attendance to identify the absent date

    Mr. Vikas_gautam like sktneer really you guys are great.. thanks a lot.. this is what i am looking for.. Godbless you guys...


  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: Attendance to identify the absent date

    @junbone
    Thanks. If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

  9. #9
    Registered User
    Join Date
    09-20-2014
    Location
    riyadh
    MS-Off Ver
    2013
    Posts
    9

    Re: Attendance to identify the absent date

    guys really thanks a lot... you are the hero in this forum

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to get specific absent dates from employees attendance data
    By dineshjangir in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-13-2019, 02:50 PM
  2. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  3. how to get specific absent dates from employees attendance data
    By dineshjangir in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2014, 05:12 AM
  4. [SOLVED] How to identify absent employees across 2 worksheets with results on a 3rd worksheet
    By jshimko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-28-2013, 12:14 PM
  5. [SOLVED] Determine last date of attendance as we considered weekend, public holiday and absent date
    By ashburnadam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2012, 12:08 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1