Project a date and calculate a % in one formula
 

See two colums below. My formula needs to calculate 60 days out from the
given date in Col A , then from that date give me an annualize 6% from the
caculated date until 11/16/09. I have beat my head against the wall on this
one. Thanks


Col A Col B
01/05/05 528.00
01/08/05 482.63
01/08/05 544.50
01/10/05 700.87


bert_lady

Project a date and calculate a % in one formula
 

Think this will get what you want:

=ACCRINT(DATE(YEAR(A2+60),MONTH(A2+60),DAY(A2+60)) ,DATE(YEAR(A2+60)+1,MONTH(A2+60),DAY(A2+60)),DATEV ALUE("11/16/2009"),0.06,B2,1)

"bert_lady" wrote:

See two colums below. My formula needs to calculate 60 days out from the
given date in Col A , then from that date give me an annualize 6% from the
caculated date until 11/16/09. I have beat my head against the wall on this
one. Thanks


Col A Col B
01/05/05 528.00
01/08/05 482.63
01/08/05 544.50
01/10/05 700.87


bert_lady

Project a date and calculate a % in one formula
 

--
bert_lady


"Sean Timmons" wrote:

Think this will get what you want:

=ACCRINT(DATE(YEAR(A2+60),MONTH(A2+60),DAY(A2+60)) ,DATE(YEAR(A2+60)+1,MONTH(A2+60),DAY(A2+60)),DATEV ALUE("11/16/2009"),0.06,B2,1)

"bert_lady" wrote:

See two colums below. My formula needs to calculate 60 days out from the
given date in Col A , then from that date give me an annualize 6% from the
caculated date until 11/16/09. I have beat my head against the wall on this
one. Thanks


Col A Col B
01/05/05 528.00
01/08/05 482.63
01/08/05 544.50
01/10/05 700.87


bert_lady

Project a date and calculate a % in one formula
 

Thanks Sean,

I still don't get what the repeat of the Date functions does in this
operation, also the Year +1 - what am I missing?
--
bert_lady


"Sean Timmons" wrote:

Think this will get what you want:

=ACCRINT(DATE(YEAR(A2+60),MONTH(A2+60),DAY(A2+60)) ,DATE(YEAR(A2+60)+1,MONTH(A2+60),DAY(A2+60)),DATEV ALUE("11/16/2009"),0.06,B2,1)

"bert_lady" wrote:

See two colums below. My formula needs to calculate 60 days out from the
given date in Col A , then from that date give me an annualize 6% from the
caculated date until 11/16/09. I have beat my head against the wall on this
one. Thanks


Col A Col B
01/05/05 528.00
01/08/05 482.63
01/08/05 544.50
01/10/05 700.87


bert_lady

Project a date and calculate a % in one formula
 

the first date is the original date of the loan. The second date is the first
compounding date. I presumed you wanted to compound on the 365th (or 366th)
day from the initiation date. If you want to compound on, say, 12/31 of the
year, you can do =DATEVALUE(DATE(YEAR(A2+60),MONTH(12),DAY(31)) at the
beginning.

"bert_lady" wrote:

Thanks Sean,

I still don't get what the repeat of the Date functions does in this
operation, also the Year +1 - what am I missing?
--
bert_lady


"Sean Timmons" wrote:

Think this will get what you want:

=ACCRINT(DATE(YEAR(A2+60),MONTH(A2+60),DAY(A2+60)) ,DATE(YEAR(A2+60)+1,MONTH(A2+60),DAY(A2+60)),DATEV ALUE("11/16/2009"),0.06,B2,1)

"bert_lady" wrote:

See two colums below. My formula needs to calculate 60 days out from the
given date in Col A , then from that date give me an annualize 6% from the
caculated date until 11/16/09. I have beat my head against the wall on this
one. Thanks


Col A Col B
01/05/05 528.00
01/08/05 482.63
01/08/05 544.50
01/10/05 700.87


bert_lady