Re: Date arithmetic



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]