increasing a cell by 1

[Debra]

I have a user who would like to increas one cell in his spreadsheet by one at
midnight every night. Is this possible ? I have searched Knowledgebase and
can't find a clear solution.
I would appreciate any help since I'm not that knowledgable in Excel.
Debra

 

[Carim]

Hi Debra,

Take a look at Chip's comprehensive solution ...

http://www.cpearson.com/excel/ontime.htm

HTH
Cheers
Carim

 

[Don Guillett]

Sure but how about
=today()-a1
where a1 is the starting date

 

[Debra]

Thank you both. I will try both solutions and write back
Debra