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
Help Article Resources
Check out the Formula Handbook template!