[svlug] OOo Calc increment month

[Paul Cubbage]

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)