+ Reply to Thread
Results 1 to 3 of 3

need help in creating absence rate formula and tracking sheet on monthly basis

  1. #1
    Registered User
    Join Date
    05-01-2014
    Location
    kuwait
    MS-Off Ver
    Excel 2007
    Posts
    2

    need help in creating absence rate formula and tracking sheet on monthly basis

    Dear Seniors,

    I have searched a lot online but could not be able to find a suitable format for creating absence tracking sheet with absence rate formula on monthly basis.

    I need help in creating an excel sheet with the below requirements:

    Column A,B,C,D: Employee Name, Dept,Absence date(From - To), Total Days, Type of Leave (S, A, M, etc)

    Additionally I need a calculation at the end that shows the absence rate during the specific month in the form of table or statistical graph.

    I would appreciate if you could help me in this.

    Regards,

    Atif

    firefox1_uk@hotmail.com

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,320

    Re: need help in creating absence rate formula and tracking sheet on monthly basis

    if you could setup a sample spreadsheet and attach that would help
    I would report your post and ask a moderator to remove your email address - putting email on public forums is a quick way to get a lot of spam

    you could use the datedif() http://www.techonthenet.com/excel/formulas/datedif.php function to calculate the number of days

    a pivot table would be able to give you a table and chart showing monthly type of absence Absence date(From - To) use two columns , 1 for from and 1 for two
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    05-01-2014
    Location
    kuwait
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: need help in creating absence rate formula and tracking sheet on monthly basis

    Thank you very much.

    I am new to this forum and will keep the forum rules in mind in my future posts.

    Kind Regards,

    Atif

+ 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. Replies: 1
    Last Post: 02-28-2014, 02:31 AM
  2. Vlookup and Formula needed to calculate total cost by monthly basis
    By watson853 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2013, 09:31 PM
  3. Absence Tracking (97-2000)
    By st3ady in forum Excel General
    Replies: 4
    Last Post: 12-12-2012, 12:30 PM
  4. Replies: 5
    Last Post: 08-03-2012, 01:43 AM
  5. [SOLVED] A formula for monthly tracking?
    By Jlabbe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2006, 02:45 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