|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
09-01-2007, 05:27 PM
|
|||
|
|||
|
Counting the days worked and days remaining on a schedule automatically
I've saw an excel spreadsheet that did this before; however, I have no idea where to start on this. I'm basically looking for a forumla that will count each employees total scheduled work days for the month inserted and then depening upon the day it is will show how many days the employee has left to work for the month.
|
|
#2
09-01-2007, 06:03 PM
|
||||
|
||||
|
Hello uhcord98,
Really, given your setup, to calculate this using formula(s) is possible but much trickier than it could be if your setup was different. I understand that you probably want to show the schedule in weeks as you have but it would be much easier if you had all the dates down column A and employee names across row 1. At the very least you need to use "true dates" in row 2, 11, 20 etc. Just so that I understand what you want....you talk about "the month"....are you referring to the calendar month or do you consider the whole 6 weeks shown to be a month? Would the current day be part of the days worked or days remaining?
|
|
#3
09-01-2007, 06:08 PM
|
|||
|
|||
|
I actually worded it wrong, I'm sorry.
What I was looking for is to count the total number of scheduled work days (for each employee) for the month and display this data. In addition to this, I was looking for excel to see hey it is September 15th, only count the days from here on to display total days left to work for the month.
|
|
#4
09-01-2007, 06:26 PM
|
|||
|
|||
|
So I changed the format, I put the dates into column 1 and have the employees displayed in the rows going across.
I put the formula in to count the total days worked, and I just need to figure out a formula to count the scheduled work days left for the month.
|
|
#5
09-02-2007, 10:03 AM
|
||||
|
||||
|
Try
=SUMIF(A2:A32,">"&B35,B2:B32)
|
|
#8
09-03-2007, 01:17 AM
|
|||
|
|||
|
I've ALMOST got it figured out.
What I did is made another sheet that has each date with how many days is left (on each date i put in a seperate formula that only counts from that day on). Lengthy to get going I know, but once the workbook is complete it will save me hours everyday. Now, all I need is a formula that will look at the date I enterted, go to sheet 3 and insert the value right beaneth that date. (So if I enterted "3rd" for today's date, it would go to sheet 3 and look at the value right under the "3rd"). I posted an update workbook.
|
|
#9
09-03-2007, 08:28 PM
|
||||
|
||||
|
Quote:
|
|
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
