Error when using =Month formula if no date in a column
I am using the following formula:
If my "Due Date" cell is empty I get the following error
#INVALID DATA TYP
I may not always know the Due Date until the project moves on for some task.
I am looking for away to modify the formula to ignore a blank Due Date and give me nothing or return a "0"
Any help would be greatly apricated
Help Article Resources
Check out the Formula Handbook template!