Calculating date and placing the value in the right date range col
 

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?

Calculating date and placing the value in the right date range col
 

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?

Calculating date and placing the value in the right date range col
 

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?