Formatting Date Using & Statement

[Gian624]

Hello All,

I have a cell that states "INVENTORY (8/8/12)" (Cell A15). Each day I need to update that cell with the new day. In another cell (Cell D7), I have the date written. I would like to change the date one time in the cell D7 and have cell A15 automatically say the same thing. I do not want to use the formula that allows you to open the document and it automatically reads the days date for other reasons (I think it is something like =Today()).

Something I had in mind was using a formula like ="INVENTORY"&"("&D7&")"

However, when I use that formula, I get INVENTORY (41129) instead of the desired INVENTORY (8/8/12)

Does anyone know how I can format the D7 in the formula to read as a date rather than as numbers?

Thank you all,
Matt

 

[pjmorris]

try ="INVENTORY" & Text(D7,"(dd/mm/yy)")

note I'm in UK so not sure whether you want dd/mm/yy or mm/dd/yy

Hope this helps.

 

[VoG]

Try

="INVENTORY "&TEXT(D7,"mm/dd/yyyy")

 

[Gian624]

Thank you everyone, that worked perfectly!