| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Project dates | Excel Discussion (Misc queries) | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| How do I calculate dates backwards from a project end date | Excel Worksheet Functions | |||
| How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions | |||
Linear Mode
