I am trying to get days between 2 dates with the following formula.

=NETDAYS([End date]3, [CR1 - Fabric yardage]3)

One of the dates came from another sheet, with formula. If I type a date on top, the formula works fine.

How could I fix it?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    There is the issue. The + "" on the end is converting it to a text string instead of a date value. Is there a reason for this?

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!