Return Blank Result for Date + Days with No Date

[WDETR]

I have over 200 rows (adding daily) and need to identify the Expected Return Date using 21 days from Email Sent (Date).

Everything works fine when there is a date in Col N but I can't figure out how to get rid of the 1900-01-21 when the sent date is blank.

Goal: Col O would return a blank result when there is not date in in Col N.

 

[Fluff]

HI & welcome to MrExcel.
How about

=if(N15="","",N15+21)

 

[JamesCanale]

=if(N15<>"",N15+21),"")

 

[Fluff]

@JamesCanale You seem to have an extra ) in there.

 

[WDETR]

That worked =if(N15="","",N15+21)

Awesome thank you!!!!!!

 

[Fluff]

Glad we could help & thanks for the feedback.