Days Formula that does not go below zero

[PierremontQuaker03]

Hi I am after a formula that when the number of days left goes beyond zero - stays at zero i.e. I don't want a negative number of days. See attached column O and column S. Can anyone help?

 

[Mariya]

Hi Pierr,
I checked your file out . It's logical when you sibtract smaller from bigger number to get a negative sign. If this is what you want, did you try with combination of IF function?

 

[PierremontQuaker03]

cheers , thanks

 

[bosco_yip]

Try,

Change your formula from this :

=L4-$O$2

Into this :

=MAX(0,L4-O$2)

Regards