View Single Post
  #1   Report Post  
Brw
 
Posts: n/a
Default 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?