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!
Bookmarks