Help with Networkdays formula

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

i have a vacation calendar sheet. I am using the networkdays formula to calculate vacation days

=NETWORKDAYS([Start Date]10, [End Date]10).

The problem is that if there is not a start date and and end date entered into the cell it comes back with an "invalid data type." I am also using a formula to calculate remaining vacation days.

=SUM([Vacation Days Allowed]@row - [Vacation Days]@row)

When the Networkdays formula returns an "invalid data type" it also causes the remaining vacation days  formula to come back with the same.

I need to be able to have it to where if the start date and end date are blank it wont return an invalid data response.

I've attached a few screenshots to illustrate.


Screen Shot 2019-08-01 at 9.15.43 AM.png

Screen Shot 2019-08-01 at 9.15.56 AM.png

Screen Shot 2019-08-01 at 9.16.10 AM.png

Screen Shot 2019-08-01 at 9.16.33 AM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!