formula if date entered into a different cell if not left blank instead of invalid data type.

Hi I am using a formula which works really well to calculate worked days based on dates entered in two different columns, however if dates in those columns have not yet been entered, the cell showing the calculation shows invalid data type, i want the formula to work if date is in a column and show nothing if the date is yet to be entered.

cheers

Rob

hope this makes sense.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!