with if function
 

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

with if function
 

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

Jerry

Rao Ratan Singh wrote:

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

with if function
 

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))))
--
Don Guillett
SalesAid Software

"Rao Ratan Singh" wrote in message
...
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