NETWORKDAYS function help
I am creating a column that calculates the number of days between the "Finished Date" column and the "Needed By" column.
The original function was: =SUM([Finish Date]@row - [Needed By]@row)
We want to include only working days (M-F) and exclude holidays from this count of these days.
Sometimes the finished date rows will be blank because the project hasn't been finished, so we would want the new column to be blank instead of having an error.
Some help would be great!!
Help Article Resources
Check out the Formula Handbook template!