Decrease a cell value daily.

Anonymous
2021-02-06T21:29:43+00:00

I am working on an a project and for each day, I am required to decrease a cell value by one.

For instance, on 01/14/2021 cell B2= 91 and I need the value to decrease by 1 until it reaches 0. 

Whta formula could I use so that the value decreses on its own ?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2021-02-06T22:02:53+00:00

    Enter the start value 91 in another cell, say in Z1.

    In B2, enter the formula

    =MAX(Z1-(TODAY()-DATE(2021,1,14)),0)

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-02-08T01:28:27+00:00

    Okay! I will try it out and let you know how it goes. Thank you so much

    Was this answer helpful?

    0 comments