Why is my NETDAYS function returning a result of more than 36,000

I'm trying to find the difference between today and a prior date, in this image it's the Helper Date column. I've confirmed this is an actual date format with the ISDATE function and it's working as expected in some other formulas. In this formula the result for the row displayed should be 18 days but I'm getting a result of 36,544. I've tried using today both from a 2nd column and within the formula such as shown here. Ideas?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!