Forum Discussion
IS THERE A WAY TO AUTO COUNT THE DAYS IN B EVERYTIME IT IS OPENED?
FOR EXAMPLE, IF I OPEN IT 3 DAYS FROM NOW COLUMN B WOULD READ 484?
You should have a column that lists the starting date of each row.
Let's say this is column T.
You can then use the formula =TODAY()-T2 in cell B2, and fill down.
So, I added a column with the starting date, but I need the days in the column C to change, how do I do that? I need them tomorrow to show 482. I'm sorry If I am not understanding.
In C2, enter the formula
=IF(B2="", "", TODAY()-B2)
Apply General as number format to C2. Then fill or copy to the cells below.
The result will automatically be updated each day, because TODAY() always returns the current date.
