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

Richard Mancusi vrman49 at gmail.com
Thu Apr 6 09:56:59 PDT 2006


Way to go Marco!!! - you nailed it.  I ran it from Jan 31, 2006
to Dec 31, 2010 and it was perfect.  It even got the leap year
on Feb 29, 2008.  Very impressive.

tnx
Rich


On 4/6/06, Marco Walther <marco at sonic.net> wrote:
>
> The following should go to the end of the next month iff the date is at
> the end of the current month. Otherwise it will advance to the same day at
> the next month but not after the end of that month.
>
> =IF(DAY(A1)=DAY(EOMONTH(A1;0));DATE(YEAR(EOMONTH(A1;1));MONTH(EOMONTH(A1;1));DAY(EOMONTH(A1;1)));DATE(YEAR(EDATE(A1;1));MONTH(EDATE(A1;1));DAY(EDATE(A1;1))))
>
> I never though I could do something useful in spreadsheets;-)
>
> Thanks,
> -- Marco




More information about the svlug mailing list