title: How do I get next Thursday from a random date?
body: <p>What I want to do is so you have a list of random dates, it will never be the same so it has to be a universal formula, but you get any date, any date of the year and then every Thursday is the Starting of a new week. For each date you set the date equal to the Thursday that it is greater than the previous and less than the Thursday.</p>
  
  <p>Example to clarify since I am being vague, say you get June 24th, 2012. June 24th is greater than June 21st, 2012 (which is the previous Thursday) and it is less than June 28th, 2012, which is the next Thursday. This means it should generate the value June 28th, 2012 in the column next to it.</p>
  
  <p>Is that making any sense? Based on any date value you get, you calculate which Thursday date it should generate? Any way to do this in excel?</p>