Convert Dates to text

[lmullenjr]

I am trying to convert a date - 2/3/06 - into text format to run an
INDIRECT formula. I want the date to convert to 02-03-06 as text.
Would there be a way to do this without having to retype the date?

drummer

 

[Guest]

use this function:
Cell A1: Date
A2=TEXT(MONTH(A1),"00")&"-"&TEXT(DAY(A1),"00")&"-"&RIGHT(YEAR(A1),2)

 

[Andrew Taylor]

With the date in A1, use =TEXT(A1,"dd-mm-yy")
or =TEXT(A1,"mm-dd-yy") if you're using US-style dates.

 

[Franz Verga]

I am trying to convert a date - 2/3/06 - into text format to run an
INDIRECT formula. I want the date to convert to 02-03-06 as text.
Would there be a way to do this without having to retype the date?

drummer

Hi,

try this:

=Text(A1,"dd-mm-yy")

to have the date in a day-month-year format, or:

=Text(A1,"mm-dd-yy")

to have the date in a month-day-year format,

where your date is A1.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy