View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Jerry W. Lewis
 
Posts: n/a
Default 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