Advertisement

Advertisement

 Search Search for: Business ApplicationsAll Forums

# Solved: Excel Attendance (Formula Needed)

 KDthekid
Member with 4 posts.
THREAD STARTER

Join Date: Jul 2012
28-Jul-2012, 10:25 PM #1
Solved: Excel Attendance (Formula Needed)
Hello Everyone,

I need a formula that counts the # of days an employee did continuously come to work before they had an absence. The three different kinds of absences are Sick (S), Vacation (V), and Other (O). So for example if a person came to work Jan 1st -5th and was absent on the 6th. I need a cell that has "5" in it after P, O, or S shows up in cell (denoting how many days that person came to work in a row before they had an absence?)

I have attached a sample of how this was formulating in my head, but feel free to change this and make it how it should be.

If anyone can help, thanks in advance.
Attached Files
 For Tammy.xlsx (9.3 KB, 110 views)

Last edited by KDthekid; 29-Jul-2012 at 08:24 AM..
 samexcel
Member with 27 posts.

Join Date: Jan 2012
Location: Kolkata
Experience: Intermediate
29-Jul-2012, 03:29 AM #2
Quote:
 Originally Posted by KDthekid Hello Everyone, I need a formula that counts the # of days an employee did continuously come to work before they had an absence. The three different kinds of absences are Sick (S), Vacation (V), and Other (O). So for example if a person came to work Jan 1st -5th and was absent on the 6th. I need a cell that has "5" in it after P, O, or S shows up in cell (denoting how many days that person came to work in a row before they had an absence?) I have attached a sample how this was formulating in my head, but feel free to change this and make it how it should be. If anyone can help, thanks in advance.
Hi KDtheKID

PLease attach the file once again so that i can try to solve your prob.
 KDthekid
Member with 4 posts.
THREAD STARTER

Join Date: Jul 2012
29-Jul-2012, 08:24 AM #3
Sam I attached it thanks for your help.

Last edited by KDthekid; 29-Jul-2012 at 09:21 AM..
 samexcel
Member with 27 posts.

Join Date: Jan 2012
Location: Kolkata
Experience: Intermediate
29-Jul-2012, 11:15 AM #4
hi,

i have tried to find a solution for you, and uploaded the file please have a look and reply me if it work for you.
Attached Files
 For%20Tammy(1).xlsx (16.7 KB, 78 views)
 KDthekid
Member with 4 posts.
THREAD STARTER

Join Date: Jul 2012
29-Jul-2012, 04:32 PM #5
Thanks Sam. But I needed something that counted the # of presents since the last absence.....if its even possible. Like if they came to work the 1st though the 5th then was absent on the 6th it would have 5 under a "# of Presents since the last absence" heading. Then say they came the 7th and missed the 8th a 1 would populate. I think it it may need a Today function maybe.....

But Thanks for this one too. I will use the one you attached above for just general attendance.
 20_2_Many
Member with 518 posts.

Join Date: Jun 2012
29-Jul-2012, 07:16 PM #6
New Sheet CDI
Apologies - I redid the format of the page, and I used only "I" for 'Came In'. You can add the the people you want in the joining columns, but I left the formatting (cell colors and adding the dates of the month, and weekends (which on this have to be 'I") up to you. Hope this is kinda what you meant. Macro to run is "ConsecutiveDaysIn"
Attached Files
 For TammyCDI.xls (45.0 KB, 55 views)
 Garf13LD
Member with 455 posts.

Join Date: Apr 2012
Experience: Intermediate
29-Jul-2012, 08:57 PM #7
Non Macro Solution
Attached Files
 For Tammy.xlsx (11.1 KB, 65 views)
 KDthekid
Member with 4 posts.
THREAD STARTER

Join Date: Jul 2012
30-Jul-2012, 09:08 PM #8
Thank You Garf13LD! That is exactly what I needed! Thank You guys so much for solving this.
 techguy.org/1063001
As Seen On

WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

### Find the solution to your computer problem!

 Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 Thread Tools

WELCOME
FOLLOW US
You Are Using: