+ Reply to Thread
Results 1 to 2 of 2

how to get specific absent dates from employees attendance data

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    8

    Post how to get specific absent dates from employees attendance data

    dear all,

    i have 1 problem in employes master toll
    i want to absent dates in last coloum plz help me
    in master rool
    a= staff id, b=name,c=designation,d=star dates,ah=end dates
    like that
    D E F G AH
    1/05/2014 02/05/2014 03/05/2014 04/05/2014 CONTINUE DATES END DATES 31/05/2014
    p p A A A

    I WANT FORMULA HOW TO COUNT ABSENT DATES
    PLEASE HELP ME

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: how to get specific absent dates from employees attendance data

    Hi,

    Please post a sample template of your workbook, this can be done using COUNTIF.

+ 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. [SOLVED] Daily Attendance Sheet of Employees for Gross Salary
    By it_electronics2000 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-17-2015, 01:00 AM
  2. [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
  3. [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
  4. [SOLVED] calculate the absent of a specific person for whole year
    By dinesh4you in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-08-2012, 02:26 AM
  5. [SOLVED] Formula for dates-hire dates of employees
    By shunt in forum Excel General
    Replies: 2
    Last Post: 01-24-2006, 07:15 PM

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