Thanks, this works perfectly.
"Dave O" wrote:
Within the CONCATENATE() function, instead of referring to the date
cell alone, refer to it by nesting the TEXT() function. For instance:
if your date cell is A1 and you're concatenating it with cell B1, your
formula would look something like this:
=CONCATENATE(TEXT(A1,"mm/dd/yyyy"),B1)
You may need to change the arguments of the TEXT function to fit your
specific application.
|