#INVALID DATA TYPE need to be blank instead
I need help, I'm creating a formula to calculate to number of night which mean (-1 for the returning date).
Current formula: =NETDAYS([Tentative Departure Date]@row, [Tentative Returning Date]@row) - 1
Works well but when departure & returning date are blank I #INVALID DATA TYPE.
What to do?
Help Article Resources
Check out the Formula Handbook template!