NETDAYS #INVALID DATE TYPE

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?


Thanks!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!