with if function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))))
 
Back
Top