I want to calculate a date and then place the date value in the correct
column. Columns will be date ranges.
For example, I calculate a date to be 7/15/09. I have columns with 2 week
ranges such as:
Column A B
C
6/29/09 - 7/12/09 7/13/09 - 7/26/09 7/27/09 -
8/9/09

I want the 7/15/09 date value placed under the B column at the current row
position.
Any ideas?