increasing a cell by 1
 

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

increasing a cell by 1
 

Hi Debra,

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

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

HTH
Cheers
Carim

increasing a cell by 1
 

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

--
Don Guillett
SalesAid Software

"Debra" wrote in message
...
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

increasing a cell by 1
 

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

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Debra" wrote in message
...
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