| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intersection of Week
I have a worksheet set up with dates(merged cells) and departments(tw
separate cells) on the top and names on the side like this: 06/01-03 06/04-10 06/11-17 Ship Main Ship Main Ship Main Bob Jim Lisa Bill Now I have another sheet that someone puts in the date and the name an the department, and hours worked in that department. My question is, how do I (1) Get the date in the right column if i falls in or on the start or end date, then (2)how do I get it to be in the shipping or maintenance column -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| week end and week so far results formular in % format | Excel Discussion (Misc queries) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
![monagan[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
