I also did your example, and all the shows up on my spreadsheet is:
18/07/1900
what does this mean?



"Shane Devenshire" wrote:

Hi,

For one cell this seems reasonable, but for an entire spreadsheet?

1. Say it was one cell, A1, and the current value as of today is 200
replace the value 200 with the formula
=200+TODAY()-39781

Starting tomorrow this cell will increase by 1 each day.

Its only going to be automatic if you use a formula or write code.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Jess" wrote:

Hello, I am just wondering if it is possible to make it so that the numbers
in my spreadsheet increase by 1 everyday, without me having to go in and
manually change them everyday, as this is tedious.
Any Help Here?

(I am not sure which version it is, but its either 2007 or 2008)