Need to create a Concatenate formula that displays on a conditional basis

[chrisnw20]

I am using the below formula to generate a comment that displays when a report will expire. Because I added the text "This report will expire on" directly into the concatenate function arguments box it is constantly displayed. I want the cell to be blank if there is no date in the third party expiration!D13 cell.

=CONCATENATE("This report will expire on"," ",TEXT('Third Party Expiration'!D13,"mmmm d, yyyy"))

This formula is constantly displayed as "This report will expire on"
When there is a date in the D13 cell then an example display is "This report will expire on August 8, 2013"

When D13 contains no date- I do not want the words "this report will expire on" to show up. How can I alter this formula to have the cell left blank on a conditional basis.

Thanks!

[Fotis1991]

Perhaps..

=IF('Third Party Expiration'!D13="","",CONCATENATE("This report will expire on"," ",TEXT('Third Party Expiration'!D13,"mmmm d, yyyy")))

[chrisnw20]

Thank you!! Works great!

[Fotis1991]

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.