Help with Networkdays formula
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.
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.
Help Article Resources
Check out the Formula Handbook template!