Calculating Days remaining

%3CLINGO-SUB%20id%3D%22lingo-sub-2803640%22%20slang%3D%22en-US%22%3ECalculating%20Days%20remaining%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2803640%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20one%20cell%20I%20am%20calculating%20days%20remaining.%26nbsp%3B%20I%20would%20like%20for%20the%20days%20remaining%20to%20stop%20when%20there%20are%20no%20days%20left%20and%2For%20if%20the%20progress%20fields%20equals%20zero.%26nbsp%3B%20I%20am%20trying%20to%20use%20the%20IF%20command%20but%20can't%20figure%20out%20how%20to%20get%20it%20to%20work.%26nbsp%3B%20So%20far%2C%20I%20am%20calculating%20days%20remaining%20with%20the%20following%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DH11-TODAY()%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20I%20add%20to%20this%20formula%20so%20that%20it%20stops%20calculating%20when%20there%20are%20zero%20days%20left%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2803640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2803665%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20Days%20remaining%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2803665%22%20slang%3D%22en-US%22%3E%3DMAX(H11-TODAY()%2C0)%3C%2FLINGO-BODY%3E
Occasional 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
=MAX(H11-TODAY(),0)

@tracie3320 

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