NETDAYS formula returning negative number


I am working with a formula that calculates the number of years remaining between two dates. Several of the date have long passed and are returning a negative number. I would like all date results retuning negative numbers to simply return as zero. What changes are needed to the current formula to achieve this goal?  

=NETDAYS(TODAY(), [Warranty Expiration Date]@row) / 365

Thank you,

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!