I have come up with a solution.
Using this formula:
=ROUNDUP(AVERAGE(O5;O6;O4);0)
This smooths out my data pretty well for series that do not have a big gap.
I am pretty certain that there is something more elegant out there.
If someone knows another way to do this then please let me know.
Thanks.