Don't Show Value If Empty

[.Justin]

I am moving all of our training records from single sheets of paper to one excel workbook.

What I have is two columns per qualification, one that is for date gained and one for expiry date (3 years from date gained).

The expiry date I have the following formula

=EDATE(G3,3*12)

However where the employee does not have the qualification the expiry date is giving a value of 31/12/1902

Is it possible to only show a date if the gained column has data in it?

Thanks

 

[arnelgp]

use:

= If(IsBlank(CellToInspect),"", EDATE(G3,3*12))