Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 9 of 9 Posts

·
Registered
Joined
·
8 Posts
Discussion Starter · #1 ·
My Challenge:
I have a table with 34 different date ranges representing individual rounds 1 to 34.

Start End Round
04/12/2009 05/15/2009 1

In another worksheet I have a long "to do list" of different tasks which have start and end dates. I would like to set this sheet up so that in a "Round" column, a formula would calculate which round each task is in, given its end date.

Task Start Date End Date Round
Final Material Review 31-Aug-09 31-Oct-09 0

I believe I may need to use either a VLookup or IF formulas, though from what I understand of IF formulas it would be far to complex with 34 different date ranges. I am not sure how to use a VLookup with date ranges in this senario.
 

·
Registered
Joined
·
8 Posts
Discussion Starter · #3 ·
What I would like is for the formula to select the appropriate Round, based on the end date of the task which should fit within one of the 34 rounds.

I will be forever indebted to you if you can figure this out. For whatever reason, it is rather perplexing to me.
 

·
Registered
Joined
·
7,837 Posts
Can you copy your worksheets (delete/change any data that might be confidential) and, given that the one has a long list, zip them and then post them here? (To do that, click on the "Go Advanced" button below the posting area and you will see a button marked "Manage Attachments." Click on that and you will be able to browse for your file.)
If that doesn't work for you (sometimes newcomers to the forum haven't been able to post a file until they have 10 or so messages,) let me know and we can arrange for you to email them to me.
 

·
Registered
Joined
·
8 Posts
Discussion Starter · #5 ·
I appears it will not allow me to attach anything. If you are ok with it, I could certainly email a sample document, which would contain the "rounds" list along with a shortend sample of the document I'm working with.
 

·
Registered
Joined
·
7,837 Posts
no problem - I think that inability is to prevent spamming software from attaching items. email me at loche at rocketmail dot com
Are these two separate workbooks or two worksheets in the same workbook? While the principle is the same, it is almost always easier to keep them in the same workbook, for both have to be open in order for the references to compare,
 
1 - 9 of 9 Posts
Status
Not open for further replies.
Top