How to hide 1/0/00

[Alakazam IT]

I found a simple answer to this in another forum but I am unsure how to apply it to my situation.

This is the formula I'm using.

=DATE(YEAR(H2)+G2,MONTH(H2),DAY(H2))

Where G2 is the number of years the warranty is in place, H2 is the current date of the build, and I2 is the calculated expiration date. How should this formula look to hide the 1/0/00 return?

 

[Rick Rothstein]

Maybe this...

=IF(H2="","",DATE(YEAR(H2)+G2,MONTH(H2),DAY(H2)))

 

[bbott]

If you're getting this when H2 is empty, try:

=IF(H2="","",DATE(YEAR(H2)+G2,MONTH(H2),DAY(H2)))