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