[svlug] OT: OOo Calc increment month - fix error

Marco Walther 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?

=DATE(YEAR(EDATE(A1;1));MONTH(EDATE(A1;1));DAY(EDATE(A1;1)))

??

Thanks,
-- Marco

>
> 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.
>
> tnx
> Rich
>
> _______________________________________________
> svlug mailing list
> svlug at lists.svlug.org
> http://lists.svlug.org/lists/listinfo/svlug




More information about the svlug mailing list