ExcelBanter - How do I automatically add 1 day to a base number every day?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I automatically add 1 day to a base number every day? (https://www.excelbanter.com/excel-worksheet-functions/66844-how-do-i-automatically-add-1-day-base-number-every-day.html)

Shellbie3

How do I automatically add 1 day to a base number every day?

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.

JE McGimpsey

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.

Shellbie3

How do I automatically add 1 day to a base number every day?

Thank you. That worked perfect.

"JE McGimpsey" wrote:

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.

All times are GMT +1. The time now is 08:24 AM.