Concatenting dates..the correct format, please

[jerry.ranch]

I have two date fields that I need to concatenate

for example

A B
1 Start Finish
2 4/4/2007 4/4/2008


What I want is to display is

From 4/4/2007 to 4/4/2008

so I have a formula

= "From "&A2" to "&b2

What I get is
From 39176 to 39542
How can I get the date format in there?

Thanks
Jerry Ranch

 

[Dave Peterson]

= "From " & text(A2,"mm/dd/yyyy") & " to " & text(b2,"mm/dd/yyyy")

And if you had money...

... & text(c2,"$0.00") & ...

 

[Peo Sjoblom]

Try

="From "&TEXT(A2,"mm/dd/yyyy")&" to "&TEXT(B2,"mm/dd/yyyy")


change the format accordingly in the TEXT formula if you are not using US
date formats

 

[jerry.ranch]

Outstanding
works great
Thanks DAve

Now..if I only HAD money

 

[DF]

I have two date fields that I need to concatenate

for example

A B
1 Start Finish
2 4/4/2007 4/4/2008

What I want is to display is

From 4/4/2007 to 4/4/2008

so I have a formula

= "From "&A2" to "&b2

What I get is
From 39176 to 39542
How can I get the date format in there?

Thanks
Jerry Ranch

Try this:
="From "& format(A2, "m/d/yyyy") &" to "& format(B2, "m/d/yyyy")

-DFruge