Selecting dates

[brjohnson]

Hi,

I'm wondering if there is a quick way to select values tied to dates from a list that are X days after the starting date, with X being a variable.

For example: If I start 1/1/2000 and chose X=30 days - is there a formula I can apply to capture the 1/1/2000 value, and then every subsequent 30 day value through present?

Thanks!

 

[scottylad2]

not entirely sure what your trying to do, can you provide a sample of what you have and what you're trying to achieve? ie your layut and expected result

After getting deeper into this it looks like the function won't work for what I'm doing.



Uploaded with ImageShack.us

As I'm advancing thirty days at a time there are situations where I have multiple references in the same month. This appears to cause errors. Any ideas?

I'm still not clear what you're looking for. In your daily values you have ABC and DEF showing in January, what should you be showing for january in the Monthly values?For clarity, i'm looking at your dates and interpreting them as US dates. Month Day Year so it looks to me like you have ABC against Jan, ABC against Feb and #NA for the second Jan date.

 

[borgem]

If I may...I believe it isn't necessarily monthly, but rather every 30 days, that the OP wants to change the Values. If this is true, then a simple month match wouldn't be useful and a macro would be a more accurate solution. It would call for the user to enter in the start date and time frame and the macro then runs iterations to produce the recurring values on that interval.

 

[brjohnson]

Borgem-

Thanks for jumping in, and you are correct.

In the example I'm advancing 30 days and in reality I'll be advancing at a variable number of days - could be 15, could be 200. Is there any way to do this without a macro?

I'm afraid that, given the massiveness of my excel sheet, and my limited knowledge of macros (meaning 0) it may be too difficult for me to implement a macro based solution.

 

[borgem]

I think I'll defer to scottylad2 as it seems like he has a bit more extensive knowledge than I do when it comes to formulas that might handle that. If it comes down to a macro, I could try my hand at making one that is ready to use. I'm headed off the forums for the rest of today, but I'll be back on tomorrow to see what has transpired.

 

[borgem]

In the example I'm advancing 30 days and in reality I'll be advancing at a variable number of days - could be 15, could be 200. Is there any way to do this without a macro?

Could you, for example, advance one value for 30 days and the next for 15, and the next for 45, and so forth then? Or each time you do this, would it be values advancing on the same incremental step?

 

[brjohnson]

Once the incremental number of days is set it applies to the entirety of the data - 15 remains 15 and so on...