Date format within a text syntex?
 

I have two date fields that users enter dates into.

I have a field with the following formula where I want the dates to appear
within a preformatted sentence:

="FOR THE PLAN YEAR " & 'ENTER DATA'!B13 & " THROUGH " & 'ENTER DATA'!B15

The forula works but the dates are resulting in numbers or date values. I
would prefer to see the dates (i.e. 01/04/05)

Can excel do that?

Try:

="FOR THE PLAN YEAR " & TEXT('Enter Data'!B13, "mm/dd/yy")& " THROUGH " &
TEXT('Enter Data'!B15,"mm/dd/yy")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Brw wrote in message
...
I have two date fields that users enter dates into.

I have a field with the following formula where I want the dates to appear
within a preformatted sentence:

="FOR THE PLAN YEAR " & 'ENTER DATA'!B13 & " THROUGH " & 'ENTER DATA'!B15

The forula works but the dates are resulting in numbers or date values. I
would prefer to see the dates (i.e. 01/04/05)

Can excel do that?

="FOR THE PLAN YEAR "&TEXT('ENTER DATA'!B13,"MM/DD/YY")

HTH. Best wishes Harald

"Brw" skrev i melding
...
I have two date fields that users enter dates into.

I have a field with the following formula where I want the dates to appear
within a preformatted sentence:

="FOR THE PLAN YEAR " & 'ENTER DATA'!B13 & " THROUGH " & 'ENTER DATA'!B15

The forula works but the dates are resulting in numbers or date values. I
would prefer to see the dates (i.e. 01/04/05)

Can excel do that?