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?

I think you need a macro. don't know how you are caculating the date.
worksheets like this usually put the start date in row 1 and end date in row
2 to make the calculation a little simplier

Column A B
C
6/29/09 7/13/09
7/27/09
7/12/09 7/26/09
8/9/09



"GeorgeL" wrote:

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?

It is not helpful having the top row with text such as 6/29/09 - 7/12/09
I just used the start dates in A1:D1
29-Jun-09 13-Jul-09 27-Jul-09 10-Aug-09
15-Jul-09My 'calculated date' of 15/July/2009 is in G1
In A2 I have the formula =IF(AND($G$1=A1,$G$1<B1),$G$1,"")
This is copied across to D2
I had to format row 2 as dates otherwise I got a value of 40009 in B2


If you want both start and end dates then place them in two rows

29-Jun-09 13-Jul-09 27-Jul-09 10-Aug-09
12-Jul-09 26-Jul-09 9-Aug-09 23-Aug-09
15-Jul-09Now
my formula in A3 is =IF(AND($G$1=A1,$G$1<=A2),$G$1,"")

best wishes
--
Bernard Liengme
MVP Excel
http://people.stfx.ca/bliengme

"GeorgeL" wrote in message
...
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?