Remove DIV/O from cells

[phil_apaya]

Is it possible to incorporate a formula that ill leave cells bank rather than prodive the DIV/O result? when copynig a formula into cells below

Thanks

[NBVC]

Try:

=IF(P2="","",DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2)))

or

=IFERROR(DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2)),"")