Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining specific weekday in a range
I am OK with some Adv Beg excel techniques. But I am not sure how to get the
next step done. I do a monthly schedule in grid format in excel, names down the left (A-column), and Dates across the top(row-2). I have set up a template to auto fill the date each time I enter the new date for the month in the cell A1 range "DAY" is C2 to AG2. This starts at C2 with "=A1" then in C3 "=(c2+1)". This is formated to show text days of the week "ddd". In the lower rows for each person a letter is used to indicate where they are to work for this day. Some letters are for 12 hour shifts and some for 24hrs. This is easy, but I need to use a letter on one site that has varying hours depending on the day. For example "T" on a "Fri" equals 8 hours and "T" on "Sat", "Sun", or "Mon" equals 12 hours. I have been using the COUNTIF function to determine the number of each shift worked, but I need to distinguish between Fri and other days. Is there a simple way to evaluate a persons range (row) and if there is a "T" check to see if it is in a column that is a Friday or saturday etc? Since this column changes monthly, I need the formula to evaluate the date in the column that the "T" resides to see how to count it. If this does not make sense I have the blank sheet and can send it to anyone interested in helping. I appreciate any help anyone can give me. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I calculate dates and skip a specific weekday? | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Determining and Printing a specific page | Excel Discussion (Misc queries) | |||
Determining a specific time during the day | Excel Worksheet Functions |