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

G

GeorgeL

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?
 
J

Joel

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top