Calculation result with a maximum value

[scott_od]

Is it possible to have a formula in excel which calculates the difference between two cells, but without the result being negative (result should never be less than zero)

For example
A1 contains Invoice Date (21/09/2016)
B1 contains number of credit days (30)
C1 contains Invoice Due Date (A1 + B1)
D1 contains number of credit days remaining (C1-TODAY())

However I don't want D1 to show a negative number, the lowest number should be zero, as -19 credit days remaining does not make sense.

Thanks in advance for the help

 

[alvinwlh]

try this?

=MAX(C1-TODAY(),0)

 

[scott_od]

Many thanks Alvin, it worked perfectly