Thread: How do I automatically add 1 day to a base number every day?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default How do I automatically add 1 day to a base number every day?
One way:

=TODAY() - DATE(2005,10,18)

In article ,
Shellbie3 wrote:

I need to create a cell in excel where I can take a base number (96) and have
it add (1) every day. So that today it will be 97 and tomorrow it will be 98
and so on.
Reply With QuoteReply With Quote