software

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

=IF(ISBLANK(E146,quot;quot;,formula)

Jerry

Rao Ratan Singh wrote:

gt; Some one great MVP solved my problem with this function
gt; =(DATE(YEAR(E146),MONTH(E146) 3-MOD(MONTH(E146)-1,3),1))
gt;
gt; but i just want to do more with this function. How it can be display blank
gt; when e146 does not have any date. when this function found date on particular
gt; cell then it calculate next 3 months dat.
gt;
gt; Thanks in advance
gt;
gt; Rao Ratan Singhthis should take care of non numbers and non dates

=IF(ISTEXT(I14),quot;quot;,IF(YEAR(I14)lt;2000,quot;quot;,(DATE(YEAR (I14),MONTH(I14) 3-MOD(MONTH(I14)-1,3),1))))
--
Don Guillett
SalesAid Software

quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Some one great MVP solved my problem with this function
gt; =(DATE(YEAR(E146),MONTH(E146) 3-MOD(MONTH(E146)-1,3),1))
gt;
gt; but i just want to do more with this function. How it can be display blank
gt; when e146 does not have any date. when this function found date on
gt; particular
gt; cell then it calculate next 3 months dat.
gt;
gt; Thanks in advance
gt;
gt; Rao Ratan Singh