Using a Date in a statement with &

[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

 

[njimack]

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