adjoining cell to follow perpetual date

[mnoonan]

column A has perpetual dates. Column B has numbers that correspond to a particular date. As column A changes i need to have column B change to stay in line with it's particular date.
thanks

 

[Tom Urtis]

What's a perpetual date? Consider posting a few dates and numbers, with a description of what would change, why it would change, and what your expected result is. A visual of some kind would help to understand what you are asking about.

 

[mnoonan]

hope this helps

A B C

1 3/29/2011 1 0
2 3/28/2011 0 1
3 3/27/2011 1 0


column A is todays date, column B,C are points earned on that day. Each new day that worksheet is opened A! will change to todays date, and A2,A3 will change in relation to A1. how do I get cells in columns B,C to follow thier corresponding dates

 

[mnoonan]

here it is again, hopefully more easily explained

Excel Workbook
	A	B	C
1	date	points	points
2	4/1/2011	1	1
3	3/31/2011		1
4	3/30/2011	1
5	3/29/2011		1
6	3/28/2011	1
7	3/27/2011
8
9	total	3	3
Sheet1

Excel 2007

Cell Formulas
Range	Formula
A2	=TODAY()
A3	=A2-1
A4	=A3-1
A5	=A4-1
A6	=A5-1
A7	=A6-1
B9	=SUM(B2:B7)
C9	=SUM(C2:C7)

A2 is always current date, need the numbers in column B,C to follow their corresponding date until they fall off the worksheet

 

[mnoonan]

can anyone help with this

 

[Tom Urtis]

Why not keep it simple and insert a row at row 2 which would address your afore-posted "how do I get cells in columns B,C to follow thier corresponding dates".

A friendly tip, in your posts, your chances for getting a reply will increase if you don't use esoteric phrases. You have since explained "perpetual date" but now there's a new one, "fall off the worksheet" which you wrote within "numbers in column B,C to follow their corresponding date until they fall off the worksheet".

I'd say this to anyone, please understand I'm not nitpicking at you, just trying to help, those terms tend to stop people in their tracks and force an understanding of what you are talking about.

For example, you did not say what version of Excel you are using.

If

your version is 2007 or 2010

and

"fall off the worksheet" means you want to utilize all rows

then

that means, incredibly to some including me, that you are planning on over 1 million of these dates. The data would "fall off the worksheet" on March 4 of the year 4882. If you are using version 2003, the fall-off date would be "only" September 13 of the year 2190. A mere tick of the clock in geological terms, but for us living mortals, much longer past the date than we will be Excelling.