How can I make a formula to gradually add a new cell everyday?

[Starrizzo]

I am trying to make a formula that adds a new cell everyday

 

[SkipVought]

Hi,

You want to add a FORMULA to the next cell in the row each day?

You can't do that without some fancy VBA code.


Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[xlbo]

or are you trying to create a formula that incorporates another cell in it's calculation each day so

=SUM(A1:A2)
=SUM(A1:A3)
=SUM(A1:A4)

... etc etc ???

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question