Hi,
I am trying to replicate a single value for every 30 day calender for fourteen years. For example the time series is from 31/01/1999 to 30/11/2013.
Now I have the following given data keeping it short to give an idea;
Date Value
31/01/1999 0.1553
28/02/1999 0.1792
31/03/1999 0.1712
30/04/1999 0.1398
First of all I need to covert the monthly dates to daily which is not a problem but the corresponding value for each month needs to be repeated for the entire month. Can anyone suggest an formula that can be used to perform the task as I have to do this for upto fourteen years and therefore alot of manual copying. Any help is highly appreciated.
Thanks in advance.
Rups
I am trying to replicate a single value for every 30 day calender for fourteen years. For example the time series is from 31/01/1999 to 30/11/2013.
Now I have the following given data keeping it short to give an idea;
Date Value
31/01/1999 0.1553
28/02/1999 0.1792
31/03/1999 0.1712
30/04/1999 0.1398
First of all I need to covert the monthly dates to daily which is not a problem but the corresponding value for each month needs to be repeated for the entire month. Can anyone suggest an formula that can be used to perform the task as I have to do this for upto fourteen years and therefore alot of manual copying. Any help is highly appreciated.
Thanks in advance.
Rups