Turning monthly data into daily

[ciaran82]

Is it possible to turn monthly data into daily? Repeating the same data for four sets of five working days to turn a CPI monthly inflation index into daily data, to turn example 1 into example 2.


Example 1.

DATE VALUE
2008-01-01 212.174
2008-02-01 212.687
2008-03-01 213.448
2008-04-01 213.942
2008-05-01 215.208



Example 2:

2008-01-01 212.174
2008-01-02 212.174
2008-01-03 212.174
2008-01-04 212.174





Thanks,


Ciaran

[samba_ravi]

find the attached file

[ciaran82]

Thanks Siva,

Is it possible to make the data five days a week?

Date Var1
2008-01-01 212.174
2008-01-02 212.174
2008-01-03 212.174
2008-01-04 212.174
2008-01-05 212.174
2008-01-08 212.174
2008-01-09 212.174
2008-01-10 212.174
2008-01-11 212.174
2008-01-12 212.174



Ciaran

[samba_ravi]

=IF(C1="","",IF((C1+1)>A$5,"",C1+IF(MOD(ROWS(C$1:C2),5)=1,3,1)))
Try this formula in C2 and copy towards down