Question for excel gurus

[goatjc]

Essentially, I want a cell to display: "Days of warranty as of 6/7/2007", where the "6/7/2007" is the date of today that changes.

Right now, I have =concatenate("Days of warranty as of ",TODAY()), but, the date shows up as that random a$$ed number excel gives to dates under the text format.

Is there a different function where I can enter text then the date and get it to display properly.

Thanks!

 

[Engraver]

If you have a place on your spreadsheet with the date already on it, instead of putting TODAY in your concatenate function, you can link it to the cell.

For example, in A1 you have the date, 6/7/2007, so you enter your formula as
=CONCATENATE("Days of warranty as of ",A1)

Also be sure to set the number format of your date cell to text.

 

[mezrah]

You just need to format how you want your date to appear using TEXT:

=CONCATENATE("Days of warranty as of ",TEXT(TODAY(),"m/d/yyyy"))

 

[goatjc]

Originally posted by: mezrah
You just need to format how you want your date to appear using TEXT:

=CONCATENATE("Days of warranty as of ",TEXT(TODAY(),"m/d/yyyy"))

Winnar! Thanks a bunch! Nice try engraver, I did try linking to the cell and that didnt work.