[svlug] OOo Calc increment month
vrman49 at gmail.com
Tue Apr 4 11:16:54 PDT 2006
Thank you very much - works perfectly !!
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
> Open Country, Inc.
> 1301 Shoreway Rd. #211
> Belmont, CA 94002
More information about the svlug