I have come up with a solution, it isn't overly pretty but it works...
Note; the end of the formula in cells G2, G3 and G4 are slightly different but from G4 (31.12.2008) down they are all the same.
I am guessing there is a more elegant solution, but at this stage I think it will need someone with more than my "beginner" skill level.
You will need to swap the semicolons (;) for commas (,).
Regards.
|