FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SET
I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formula on blank cells. Can someone help me please?
Original End Date, New End Date and
Planned Task Hours
Help Article Resources
Check out the Formula Handbook template!