How To add 1 everyday?

[sasuke]

How to add 1 everyday and subtract -1 it everyday, see attached file

 

[jayalaxmi]

Hello sasuke,

I am not clear what you are exactly looking out for. If you want to subtract one day on daily basis. you can use =today()-1 as such..Or if you want to subtract a value then you can use something like this =A2-1 etc. Hope I am making sense to you.

Regards

 

[sasuke]

Hello sasuke,

I am not clear what you are exactly looking out for. If you want to subtract one day on daily basis. you can use =today()-1 as such..Or if you want to subtract a value then you can use something like this =A2-1 etc. Hope I am making sense to you.

Regards

i want automatically adding 1 to the value daily based on the date without opening the file, it was like real time update using date

 

[Atlas Johnson]

As far as I understand, you want to add or subtract 1 every day. To do so;

1. Have a start date
2. Calculate the days between Today and start date
3. Add or subtract from this number from your number

I did it for cars, I hope it works.
AJ