Forum Discussion
Solved
need help with formula
i am trying to track when evaluations are due how do i make the days left change? so if the eval is due on 10/4/2022 and i put in 85 days left how do i make it change by itself daily?
Let's say you enter the evaluation date 10/4/2022 is in cell A2.
The number of days left is returned by
=A2-TODAY()
If you don't want the number to go negative after 10/4/2022, use
=MAX(A2-TODAY(),0)
Let's say you enter the evaluation date 10/4/2022 is in cell A2.
The number of days left is returned by
=A2-TODAY()
If you don't want the number to go negative after 10/4/2022, use
=MAX(A2-TODAY(),0)
thank you!!!
