Re: Date arithmetic
- From: Dave Feustel <dfeustel verizon net>
- To: Morten Welinder <mwelinder gmail com>
- Cc: gnumeric-list gnome org
- Subject: Re: Date arithmetic
- Date: Wed, 22 Jun 2005 17:27:55 -0500
On Wednesday 22 June 2005 03:48 pm, Morten Welinder wrote:
In A1, enter 2005-06-21
In A2, enter =A1+1
Dates are just numbers formatted to look like dates.
Morten
This works on sheet 1 and fails on sheet 2 in cells with
formatting identical to sheet 1. On sheet 2 I get
I get ###. On sheet 1 the value runs over the next cell
which is blank. I can get the value to display properly in
sheet 2 by reducing the font size to 4, but it's hard to read :-)
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]