Formula
 

Hello,
Need the date in A1, 1/21/05 to equal the number 1 for sum calculation.
Help please. Thank you
Susan

Whgt should happen in the sum calculation for dates other than 1/21/05?


In article ,
"Susan" wrote:

Need the date in A1, 1/21/05 to equal the number 1 for sum calculation.
Help please. Thank you

The date should equal 1

"JE McGimpsey" wrote:

Whgt should happen in the sum calculation for dates other than 1/21/05?


In article ,
"Susan" wrote:

Need the date in A1, 1/21/05 to equal the number 1 for sum calculation.
Help please. Thank you

Then why not just use 1 in your calculation?

In article ,
"Susan" wrote:

The date should equal 1

"Susan" wrote:

Hello,
Need the date in A1, 1/21/05 to equal the number 1 for sum calculation.
Help please. Thank you
Susan


I dont have your answer looking for one of mine own I need to caculated
ending Value using cell referece contain the Numbers 281481.00 with the
result being 2,641287.83 I am caculating investmens with input of 12.000 over
a 20 year period.

Constance