Hi all,

Don't know if what I'm asking for is possible, but here goes:

I have a relatively regular cash flow data series stretching over 2 years (where there is about 3-4 transactions each month) the date of the data points varies each month. What I want to do is to make a new data series where every date that does not have a data point, gets value of 0.

Example:

This:
Date CF
02.01.10 -100
14.01.10 150
22.01.10 -30

Becomes this:

01.01.10 0
02.01.10 -100
03.01.10 0
04.01.10 0
. .
. .
. .
. .
14.01.10 150

And so on. After this, I'm going to make a graph which illustrates the cash situation at specific dates each month

Does anyone know a quick fix for automating this, or should I just make the manual dates and pick up the numbers via simple = formulas?

Appreciate any help!