[svlug] OOo Calc increment month

Richard Mancusi vrman49 at gmail.com
Tue Apr 4 11:16:54 PDT 2006


Thank you very much - works perfectly !!

Rich


On 4/4/06, Paul Cubbage <pcubbage at opencountry.com> wrote:
> Richard Mancusi wrote:
> > How do you increment a month in OpenOffice Calc?
>
> Not exactly a Linux topic:-)
>
> > Days are easy:
> > If date = 05/04/2006
> > that cell +31 = 06/04/2006
>
> In Open Office 2.0
>
> =DATE(YEAR(that cell);MONTH(that cell)+1;DAY(that cell))
>
> Should look right but you may have to set the cell formatting.
>
> > So, if all months had the same amount of days that
> > would be the answer.  Unfortunately, they don't.
> >
> > tia
> > Rich
> >
> > _______________________________________________
> > svlug mailing list
> > svlug at lists.svlug.org
> > http://lists.svlug.org/lists/listinfo/svlug
> >
> > !DSPAM:4432a833813581367313988!
> >
>
>
> --
> Paul V .Cubbage
> Evangelist
> Open Country, Inc.
> 1301 Shoreway Rd. #211
> Belmont, CA 94002
> 650-591-8080(W)
> 408-472-1112(M)
>




More information about the svlug mailing list