[svlug] OT: OOo Calc increment month - fix error
marco at sonic.net
Tue Apr 4 21:14:17 PDT 2006
On Tuesday 04 April 2006 20:21, Richard Mancusi wrote:
> I now know this is off topic, however I feel obligated to
> correct my post. I said the following works perfectly:
> =DATE(YEAR(that cell);MONTH(that cell)+1;DAY(that cell))
Does the following solve your problem?
> It doesn't. It only works if the start date is 28 or less. e.g.
> if you start with 01/31/2006 the next cell will surprise you.
> Again, sorry for the off-topic post and my incorrect validation
> of the fix. We can drop it now and I will find a work-around.
> svlug mailing list
> svlug at lists.svlug.org
More information about the svlug