date ranges

Hi, I am new to the forum! my friends talk a lot about this and glad to be in the forum using Office 2007. My question--- I work in a manufacturing company which makes different sizes of Nuts on many machines. One machine can do only one size of Nuts for a particular period and can be molded...

I am working with a spreadsheet that has 3 date ranges. One workbook contains income data based on dates from 3/1/2008 through 3/31/2009; another contains income data between 4/1/2009 and 5/31/2010; and another contains income data based after 6/1/2010. The main workbook has dates ranging over...

Hello, This may be one of those "impossibles", but I am stuck on where to even start with this formula. I am trying to use EXCEL to create a small resource schedule. Each "row' can be considered an activity or a shift. If for a particular "resource name" the resource has been double booked...

Hello, I have a set of data as described below Team Resource Start Date End Date PMO John Doe 2/1/10 7/24/10 Infra Jane Doe 3/1/10 4/23/10 ETC... I need to be able to 1st match the team and see how many resources are active for each week...

Hi everyone, I'm using Excel 2007 and I've tried a lot of different methods including VLookup and Match to solve this problem, but nothing is working. I have data like this: A B C 1 12/10/2002 10/9/2003 Period (dec. 10, 2002 - oct. 9...

Hello, I am trying to figure out a way to spread a value across a specific date range. I have a start date and end date and a calculated value that needs to match up in against that date range. Eg. Start Date - 01/01/2010 End Date - 20/01/2010 Value - 100 I want to put 100 against every...

I really appreciate anyone who can help!! Question: I want to count all the film titles that... 1. Studio Affiliated (Col B) 2. Release between 4/1/09-12/31/09 (col D) 3. Grossed between $2,000,000-4,000,000 (col F) This is just a fraction of a much large file. The answer is 2 films <table...

I am drafting a score card to track on-time completion for four tasks within a standard process. My Excel sheet currently has the following information: Column A: Period completed (we are on a 12-period calendar) Column B: Date due Task 1 Column C: Date completed Task 1 Column D: Date due Task...