Excel 2013 Date problem

[staticpony]

How do i Make the date in cell e23 show at the end of text.
Example =If (k23 >= e23 "paid ","paid on ",e23)
First part of the formula works fine but when i add the last e23 i get an error.
Thanks in advance.

 

[SunnyAlv]

Like this ?
With "&" not Comma ","

=IF(K23>=E23,"paid ","paid on "&E23)

 

[Peter_SSs]

date in cell e23 show at the end of text.

Since E23 is a date you will need to format it to include with text. perhaps this? (adjust date format if required)

=IF(K23>=E23,"paid ","paid on "&TEXT(E23,"d/mm/yyyy"))

 

[staticpony]

Thank you Peter it works just great. I used the formula with the TEXT and format column for date to show.
Once Thanks

 

[Peter_SSs]

You're welcome. Thanks for the follow-up. You don't need to format the column with the formula as Date though.