SOLVED

Calculating Days remaining

Copper Contributor

In one cell I am calculating days remaining.  I would like for the days remaining to stop when there are no days left and/or if the progress fields equals zero.  I am trying to use the IF command but can't figure out how to get it to work.  So far, I am calculating days remaining with the following formula:

 

=H11-TODAY()

 

What do I add to this formula so that it stops calculating when there are zero days left?

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
=MAX(H11-TODAY(),0)

@tracie3320 

=MAX(0,H11-TODAY())
Thank you. This works!
This works. Thank you
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution
=MAX(H11-TODAY(),0)

View solution in original post