How to simplify "multiple if" formula
I think the problem is that once you have set a cell to blank then
EDATE( ... ) will return an error if it acts upon that cell.
Try this (a variation of your second formula):
=IF(I4="";"";IF(EDATE(I4;1)$D$4;"";EDATE(I4;1)))
and then copy this across.
Hope this helps.
Pete
|