Format a date within a formula
 

I have table names that must have a 2 digit date at the end. I want to
automate a spreadsheet to use my tables names and put in the 2 digit date
using a formula.
A full, proper table name looks like this;

FAAA_2LOW_28

The 2 digit date is todays date and must be at the end with the underscore
preceding it. How can I put a formualted date in one cell, 7/28/08 using only
the 28, my table name in another cell, FAAA_2LOW, and then concatenate them
together as shown above? Everytime I try to do this the date ends up as
numbers.

Thanks in advance for any help.

Format a date within a formula
 

Use the Text function, as in:

=A1&"_"&Text(a2,"dd")

Regards,
Fred.

"SJW_OST" wrote in message
...
I have table names that must have a 2 digit date at the end. I want to
automate a spreadsheet to use my tables names and put in the 2 digit date
using a formula.
A full, proper table name looks like this;

FAAA_2LOW_28

The 2 digit date is todays date and must be at the end with the underscore
preceding it. How can I put a formualted date in one cell, 7/28/08 using
only
the 28, my table name in another cell, FAAA_2LOW, and then concatenate
them
together as shown above? Everytime I try to do this the date ends up as
numbers.

Thanks in advance for any help.

Format a date within a formula
 

hi
try this
=A1&"_"&DAY(TODAY())
but if you have a date in a cell, say b1 then
=A1&"_"&DAy(B1))

regards
FSt1

"SJW_OST" wrote:

I have table names that must have a 2 digit date at the end. I want to
automate a spreadsheet to use my tables names and put in the 2 digit date
using a formula.
A full, proper table name looks like this;

FAAA_2LOW_28

The 2 digit date is todays date and must be at the end with the underscore
preceding it. How can I put a formualted date in one cell, 7/28/08 using only
the 28, my table name in another cell, FAAA_2LOW, and then concatenate them
together as shown above? Everytime I try to do this the date ends up as
numbers.

Thanks in advance for any help.