If I have a value in Cell B:31
and I want to reference this cell in Cell B32 and add the current date the
following way how would I do it?


For instance

B:31=
ENG
I want B32 to display something like: =B31&Date."bat"
So finally cell 32 would look like: ENG6/29/07/.bat