Work Schedule

thestones757

New Member
Joined
Feb 24, 2010
Messages
24
I have a work schedule in excel using the date of the shift, the time, and the money made and so on, if I were to make weekly totals, how would I make a good equation for the total of shifts, hours, and money made? I was thinking countif but i dont know how to encompass all of the dates in a particular week without writing them all out, would really appreciate the help.


Weekly Totals
Week Shifts Hours Money
February 1, 2010 ? ? ?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

thestones757

New Member
Joined
Feb 24, 2010
Messages
24
I think it has something to do with the following formula:

COUNTIF(A3:A400,"<="&today()-7)

but I do not know how to substitute the "today" for the start of the week I desire. Once again appreciate the help
 

sachin.acharya

Board Regular
Joined
Nov 5, 2009
Messages
93
I would add a column for a Week Number and use the =WEEKNUM(Date) function to assign week numbers to each date. Then do a Pivot so that the data can be Grouped at Week level (or any other level for analytical purposes).
 

thestones757

New Member
Joined
Feb 24, 2010
Messages
24
Thanks for the response, good idea. I set that up with no problems, now i want to represent shifts hours and money. I thought shifts would be easy, i tried using the function:

=DCOUNT(D2:D400,"Week Number",Q3)

where D2:D400 is my Week Number that I have in my data section separate from my weekly chart and Q3 is the week number that I will be representing data for in my weekly chart, for some reason it is returning #value and I have tried everything. Doesn't make any sense maybe you could clear that up.

Next question is I cant even think how to Sum the number of Hours (already have a column for each shift in the data section) or Total money (again already have a column) I was thinking an If statement but that could become pretty extensive if i had to input multiple upon multiple If statements. I appreciate your help
 

Watch MrExcel Video

Forum statistics

Threads
1,099,735
Messages
5,470,437
Members
406,699
Latest member
perfectioncts

This Week's Hot Topics

Top