I have the following equation
=IF(ASSUMPTIONS!H11="-",DATE(YEAR($Z31)+5,MONTH($Z31),DAY($Z31)),ASSUMPTIONS!H11)
However, there are blank rows which creates the error #VALUE. What do I need to add into this formula to prevent the error message appearing?
Thanks
Bookmarks