I am trying to find a formula that will add or count days between today's date and various due dates to give me a total number of days. I attempted to use the datedif function and just adding each cell together and it works, but due to several columns being blank it creates an error, besides taking forever to build the formula one at a time.
I attached a screenshot of what I'm working on.
excelhelp.JPG
Bookmarks