ANother Question
Try this:
=B31&TEXT(TODAY(),"m/d/yy/")&".bat"
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"N.F" wrote in message
...
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
|