Results 1 to 10 of 10

How to calculate the number of days present using formula?

Threaded View

  1. 01-14-2015, 06:37 PM #1
    rajeshntiwari
    rajeshntiwari is offline
    Registered User
    Join Date
    01-02-2012
    Location
    Karnatak, India
    MS-Off Ver
    Excel 2010
    Posts
    34

    How to calculate the number of days present using formula?

    In below data: Out of 6 working days John was present for 3 days.

    So how to get the answer 3, using formula? Can someone please help me. Thanks

    NOTE: JOHN is attending the class twice in a day! 1st class in morning and 2nd class in evening.

    Monday John
    Monday John
    Monday Tim
    Tuesday John
    Tuesday David
    Wednesday David
    Thursday Smith
    Friday Smith
    Saturday John
    Last edited by rajeshntiwari; 01-14-2015 at 07:38 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Attendance System that Adds Point For the Month and Subtracts Points if Perfect Attendance
    By MinieMe209 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  2. attendance log
    By excellionaire in forum Excel General
    Replies: 20
    Last Post: 08-16-2011, 02:48 PM
  3. record the total possible attendance against actual Attendance
    By bajdr47 in forum Excel General
    Replies: 3
    Last Post: 06-12-2011, 02:56 PM
  4. Attendance Log
    By mwilburn01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2010, 11:31 AM
  5. Attendance
    By praveen_khm in forum Excel General
    Replies: 2
    Last Post: 02-02-2006, 04:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1