hi all,
i need your help to distribution vlaue between 2 date as
if my value =$100 and i want to distribution to 12 months start at 10/07/2006 to 10/07/2007 as
from 10/07/2006 to 31/07/2006 value=5.833,
from 01/08/2006 to 31/08/2006=8.333
,month 9=8.333 to month6/2007=8.333,
from 1/07/2007 to 10/07/2007 value=2.5000... this is for 1 year,
but i need to do that between 2 date ex.. for 6 month , 8 ,10, 4 14,16 months or for 2 years? i need it to distribution as a bove...
text1=month 7/2006,text2=5.833
text3=month 8/2006,text4=8.333
text5=month 9/2006,text6=8.833
text7=month 10/2006,text8=8.833
text9=month 11/2006,text10=8.833
...
.
.
.
textn=month 7/2007=2.500
thanks.