RE: date calculation, no date displays for blank adjacent cell

I am setting up a form and have a simple formula:

If a date is entered in cell A1, then the date displayed in A2 will be 14 days later. However, if there isn't a date in A1, I don't want anything to display in A2. Right now, because A1 is blank, A2 displays as 1/14/1900. How do I fix this? Thanks in advance!

In A2, try

=IF(ISNUMBER(A1),A1+14,"")

Unfortunately, no, it didn't. I have excel 2013, btw.

Wait, yes it did. Operator error. Thank you!

A1 needs to be recognized as a date/number value and not a text string.

Glad to hear it worked