=EDATE formula on blank cell shows as 31/12/1990?

[Adz2110]

I am using formula =EDATE(D5,$F$5) to generate an expiry date after a certain amount of months, in this instance its collum F stating how many months on from a selected date in collum D, however, if Collum D has no date the formula is showing as 31/12/1900 instead of VALUE or Blank?

 

[Fluff]

Hi & welcome to MrExcel.
That is correct, it interprets a blank cell as 0/1/1900, try

=IF(D5="","",EDATE(D5,$F$5))

 

[Adz2110]

Hi & welcome to MrExcel.
That is correct, it interprets a blank cell as 0/1/1900, try

=IF(D5="","",EDATE(D5,$F$5))

Worked a charm

 

[Fluff]

You're welcome & thanks for the feedback.