I posted recently looking for a solution to a date formatting problem, but after some time decided it would be easier to just reformat each date individually and deal with it from there.
I have a large list of trades from my companies trade log that includes delivery periods. The periods are identified by a column of start dates, and then a second column of end dates. I want to be able to consolidate all trades that include a delivery period that falls within a certain month. Here's an example:
Nov 2014 (The month that I'm trying to pull trades for)
(I want to have the data populate below, having pulled the entire rows that include the correct delivery periods)
Delivery Start////////// Delivery End
1 Jan 2014//////////// 31 Dec 2014 blah blah blah trade info
1 Oct 2014/////////// 31 Dec 2014 blah blah blah trade info
1 Nov 2014////////// 30 Nov 2015 blah blah blah trade info
etc...
etc...
Basically any delivery period that INCLUDES the month of Nov 2014, would be pulled, including the rest of the row. Anyone have a solution here?
Bookmarks