+ Reply to Thread
Results 1 to 9 of 9

Attendance Tracker,

  1. #1
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Attendance Tracker,

    hi all,,

    I had a worksheet in which i track the attendance of my employees.Please tell me how would i Keep track of the following;

    1. When ever a month is selected in the Cell A3, The days & the dates corresponding to that Month & Year should be displayed in the columns as shown in the worksheet.

    2.I want to Disable the cells which had SUNDAYS in the DAYS Column. I mean the Column SUN should not be allowed for entering data.

    3.How to Calculate the no.of Days an employee worked if he/she works for Half-a-day.

    Please help me in solving this.
    Attached Files Attached Files
    Last edited by excelkeechak; 05-12-2010 at 06:59 AM.
    THANKS
    ExcelKeechak

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Attendance Tracker,

    Try these

    1: D4: =UPPER(TEXT($A$3+D$3-1,"ddd")) and copy across

    3. AI6: =SUMPRODUCT(--(ISNUMBER(FIND("x",D6:AH6)))/2+ISNUMBER(FIND("X",D6:AH6)))

  3. #3
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Re: Attendance Tracker,

    That was amazing..!!!!!!. Thanks a lot for the Solution.

    Coming to my Second question.is there a way to disable the Column SUN either through VBA or any other technique.


    One More Query is that, Can the attendance Sheet be given a Break up into weekly when a month is selected in the Cell A3.

    Thanks in advance.

  4. #4
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Attendance Tracker,

    You could select all of the input cells starting at cell D5, and add Data Validation with a type of Custom and a formu;a of

    =OR(AND(D$4="SUN",D5=""),D$4<>"SUN")

    You can change the error message so that it tells your user what to do/not to do.

  5. #5
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Attendance Tracker,

    Quote Originally Posted by excelkeechak View Post
    That was amazing..!!!!!!. Thanks a lot for the Solution.

    Coming to my Second question.is there a way to disable the Column SUN either through VBA or any other technique.


    One More Query is that, Can the attendance Sheet be given a Break up into weekly when a month is selected in the Cell A3.

    Thanks in advance.
    I forgot to mention that my formula for part 3 assumes that you use a lower-case x for a half-day attendance.

  6. #6
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Re: Attendance Tracker,

    Yes, i had tried using your formula with the Small letter "x".I got that.thanks for the reply.

  7. #7
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Attendance Tracker,

    Did you see my post on response to point #2?

  8. #8
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Re: Attendance Tracker,

    Yeah, i saw your Formula for the second question

  9. #9
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Re: Attendance Tracker,

    Its working fine. Thanks for the Solutions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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