View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jess Jess is offline
external usenet poster
 
Posts: 60
Default Automatic Adding Daily

As I said, I am new to excel and not really sure about the numbers you are
telling me, you don't have to be so rude about it...

"David Biddulph" wrote:

The formula suggested was =200+TODAY()-39781 if the value today was 200.
Can you not work out what to do with the formula if the value today is 751?
Format the cell as General (or as number with no decimal places).
--
David Biddulph

"Jess" wrote in message
...
This helps a bunch, but as I am really new at excel, I really don't know
where to begin.
Say it says 751. I want it to change daily, without me even having to open
the document...
Will this work? And can you guide me through the process a little more
thoroughly? As if I was a two year old. lol

Thanks again for such a quick response!

"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)