Netdays Negative Return

Hi All!

I'm running into a quirk when using the netdays formula."Create Date" is a system generated column used for the start date, and "Resolution Date" is the end date.

When I have a record where the resolution date is the same as the startdate, I'm getting a -2 for the netdays between these values. Any idea what's going on?

=IF(ISBLANK([Resolution Date]@row), NETDAYS(Created@row, TODAY()), NETDAYS(Created@row, [Resolution Date]@row))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!