with if function

[Rao Ratan Singh]

Some one great MVP solved my problem with this function
=(DATE(YEAR(E146),MONTH(E146)+3-MOD(MONTH(E146)-1,3),1))

but i just want to do more with this function. How it can be display blank
when e146 does not have any date. when this function found date on particular
cell then it calculate next 3 months dat.

Thanks in advance

Rao Ratan Singh

 

[Jerry W. Lewis]

=IF(ISBLANK(E146,"",formula)

Jerry

 

[Don Guillett]

this should take care of non numbers and non dates

=IF(ISTEXT(I14),"",IF(YEAR(I14)<2000,"",(DATE(YEAR(I14),MONTH(I14)+3-MOD(MONTH(I14)-1,3),1))))